21 August, 2012

Error message when you open a Web page that uses Excel Web Access in SharePoint Server 2007: "You do not have permissions to open this file on Excel Services" or "Excel cannot load the workbook that you requested"


An Excel Access Web Part is a SharePoint technology that displays an Excel workbook from a document library. You can connect an Excel Web Access Web Part to any workbook in a SharePoint document library, and then use it on a dashboard or other SharePoint page. For example, you might want to display selected elements of a quarterly report on a dashboard.

Problem description:
You open a Web page that uses Excel Web Access in Microsoft Office SharePoint Server 2007. If Excel Web Access uses a file from a UNC path that is in a trusted location, the file does not open.

Additionally, you receive one of the following error messages:
You do not have permissions to open this file on Excel Services. Make sure that the file is in an Excel Services trusted location and that you have access to the file.
Excel Services cannot load the workbook that you requested.

Workarounds:
To work around this issue, use one or more of the following methods, as appropriate for your situation:
• Make sure that the location type for the trusted location is in UNC format. 
• Make sure that the file access method on the server is set to process account. 
• Make sure that the account that is running Excel Services has permissions to access the UNC share. 

If you have any queries/questions regarding the above mentioned information then please let me know.

I would be more than happy to help you as well as resolves your issues J Thank you

No comments:

Post a Comment

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.