Thursday, February 26, 2015

SharePoint Error - You do not have appropriate permissions to create a new workbook in the specified location

Error that happening during generating a excel document in a SharePoint document library.


Error:

Cannot open file "You do not have appropriate permissions to create a new workbook in the specified location".
Correlation ID: c9fe6615-10bb-4542-b6de-9429258b99db
Date and Time: 2/26/2015 2:34:55 PM



02/26/2015 14:32:32.54 w3wp.exe (0x2EB0)                       0x2438 SharePoint Foundation         Runtime                       tkau Unexpected System.Runtime.InteropServices.COMException: Cannot open file "You do not have appropriate permissions to create a new workbook in the specified location".    at Microsoft.SharePoint.Library.SPRequestInternalClass.GetFileAsStream(String bstrUrl, String bstrWebRelativeUrl, Boolean bHonorLevel, Byte iLevel, OpenBinaryFlags grfob, String bstrEtagNotMatch, String& pEtagNew, String& pContentTagNew)     at Microsoft.SharePoint.Library.SPRequest.GetFileAsStream(String bstrUrl, String bstrWebRelativeUrl, Boolean bHonorLevel, Byte iLevel, OpenBinaryFlags grfob, String bstrEtagNotMatch, String& pEtagNew, String& pContentTagNew) 0b836823-fd28-4d03-944a-8a89b8e12892


Solution:

  1. add the permissions of excel service owner to the db
  2. remove the Excel Services Service application
  3. recreate the excel service application as well as the following proxy
  4. set the URI of excel document library in SharePoint  excel services application - Trusted File Locations.

No comments: