Home > SharePoint Administration, SharePoint Problems/Issues > You do not have permissions to open this file in Excel Services. Make sure that the file is in an Excel Services trusted location and that you have access to the file.

You do not have permissions to open this file in Excel Services. Make sure that the file is in an Excel Services trusted location and that you have access to the file.

If you are attempting to access an Excel spreadsheet in MOSS 2007 and you receive this error message:

“You do not have permissions to open this file in Excel Services.  Make sure that the file is in an Excel Services trusted location and that you have access to the file.”
 
To fix this problem.
 
1.  Remote into or log into your SharePoint server and browse to SharePoint Central Administration.
2.  Go to the operations tab -> Services on Server and make sure that Excel Calculation Services status is started.
3.  If status is stopped, start the service.
4.  Next, check the excel service settings.  Click on your SSP -> Excel Service Settings -> Edit Excel Service Settings.
5.  If the Security section is not expanded, click on the “+”  to expand it.  Under the security settings change the File Access Method from Impersonation to Process Account.
6.  Click Ok
7.  Next, check the Trused File Location settings (SharePoint Central Administration -> SSP -> Excel Service Settings -> Trusted File Locations)
8.  If there are no Trusted File Locations, click on the “Add Trusted File Location” link.
9.  Within the Add Trusted File Location settings specify the URL of the location in the “Address” section for where the Excel documents will be.  i.e.  I usually put the root path (http://www.yoursite.com) but you can specify any location.
10.  Make sure the Location Type is “Windows SharePoin Services”
10.  If you want Trust Children for any site/subsite that is created under your specified URL then click the “Children Trusted” checkbox.
11.  This will allow all Excel documents within your root and subsites to have the correct permissions.
12.  Click Ok

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: