Posts Tagged Excel Services

This workbook cannot be opened because it is not stored in an Excel Services Application trusted location – SharePoint 2010

One of my colleagues sent me an email saying that he is getting this error (see below) whenever he tried to open an excel workbook. I just clicked the same file in the same location and I am able to open it. 🙂

But when I click on the excel file drop down –> View in Browser then I also got the same error.

The text format of the error is:

This workbook cannot be opened because it is not stored in an Excel Services Application trusted location.

To create an Excel Services Application trusted location, contact your system administrator.

According to the error message, obviously we need to add the document library path to Trusted File Locations in the Central Administration. So we will see the steps here.

Step 1: Go to Central Administration –> Manage service applications under Application Management

Step 2: Then click on the Excel Services Application

Step 3: Click on the Trusted File Locations

Step 4: Just click Add Trusted File Location under Excel Services Application

Step 5: Add the document library url (OR file location) on the Address box and check the  Children trusted check box –> Click ok

Please note: Don’t use like http://server:1010/documentlibrary1/forms/default.aspx instead of http://server:1010/documentlibrary1

If you use SSL (Secure Sockets Layer)/HTTPS connections, just add  https:// on the address.

If you want to read more about this just click here. The similar problem in SharePoint 2007 also, you can find the solution in my previous post.

After completing this configuration, you might get the “The workbook cannot be opened” error, if you want to get the solution just read here. 🙂

References:

1. http://sharepointknowledgebase.blogspot.ca/2011/12/excel-services-sharepoint-2010-trusted.html

2. http://technet.microsoft.com/en-us/library/ff191194.aspx

Advertisements

, , , , , ,

3 Comments

You do not have permissions to open this file on Excel Services OR Excel cannot load the workbook that you requested –SharePoint 2007

One of my colleagues sent an error message while using the development site of SharePoint 2007 in my office and I figured out the configuration of “Excel Calculation Services” was not done properly. It’s a very simple set-up, here we go:

1. Make sure that “Excel Services” (Actually “Excel Calculation Services”) is running. To check this out please do the following steps:

Central Administration –> Operations under “Topology and Services” click “Services on server” 

On the table below we can see the “Excel Calculation Services” is started. So it’s running 🙂

2. Make sure that, file access method of “Excel Services Settings” is using “Process Account”, instead of the Impersonation. To do this, follow these steps:

Go to Central Administration –> Home

On the left menu, under “Shared Services Administration” Select your “Shared Services” (for me SharedServices2 but default SharedServices1)

Under “Excel Services Settings” click the “Edit Excel Services Settings” 

Change the file access method to “Process Account”.

3. Finally make the following changes on the Trusted file locations under “Excel Services Settings”. Here are the steps:

Go to the “Shared Services” under “Excel Services Settings” click the ”Trusted file locations”.

You will be navigating to the Excel Services Trusted File Locations page. Then click “Add Trusted File Location”.

In the Location pane, do the following:

– Address: In this field we can enter a Document library or full portal Url (I have given Document library path). Please note: Don’t use like http://server:1010/documentlibrary1/forms/default.aspx instead of http://server:1010/documentlibrary1

– Location Type: For this field we have to select the “Windows SharePoint Services” option

– Trust Children: Ensure whether we need to be trusted the child libraries or directories, here I selected “Children Trusted”

Then click OK, that’s all! It is working huh! 🙂

References:

1. http://www.eggheadcafe.com/community/sharepoint/69/10068914/you-do-not-have-permissions-to-open-this-file-on-excel-services.aspx

2. http://blogs.msdn.com/b/andreww/archive/2009/04/21/excel-services-setup-and-getting-started.aspx

, , , , , , , , ,

3 Comments