Excel Service Settings

Excel Services Settings

Excel services have to be setup properly in SharePoint Central Administration before they are used in SharePoint. New users often forget to set these settings in central administration and they get permissions errors when they try to publish a report in SharePoint or try to access an Excel sheet. For example, one of the errors users get is:

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.

Another error related to Excel Services Settings is:

The file you selected could not be found. Check the spelling of the file name and verify that the location is correct. Make sure that the file has not been renamed, moved, or deleted, that the file is in an Excel Services Trusted Location, and that you have access to the file. If the problem persists, contact your administrator.

Here is how you configure Excel Services in SharePoint Central Administration:

1. Click SSP in SharePoint Central Administration.

2. Click Edit Excel Services settings in "Excel Services Settings" section.

3. Select Process account in "File Access Method".

Scroll down to "External Data" section and enter user's information who has appropriate permissions in SharePoint sites.

Click OK to save changes.

4. Click Trusted File Locations (See figure in Step 2)

5. Click Add Trusted File Location.

6. Add site URL in the Address box and select Windows SharePoint Services in the "Location Type". Depending on your requirements, you can select other options, for example, if you want to access files from a UNC then "Location Type" should be UNC. Check Children trusted check box.

In "External Data" section, select Trusted data connection libraries and embedded (Allow External Data section).

Click OK to save changes.

Now, you can access Excel files in SharePoint.