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

About these ads

, , , , , ,

  1. #1 by Anonymous on February 11, 2013 - 11:32 am

    The small little note after Step 5 helped me..!!! Thanks!!!

  2. #2 by hideen cameras on February 28, 2013 - 5:59 am

    Wow that was odd. I just wrote an extremely long comment but after I clicked submit my comment didn’t show up. Grrrr… well I’m not writing all that over again.

    Anyway, just wanted to say superb blog!

  1. The workbook cannot be opened – Excel Services error on SharePoint 2010 « Step Bi Step

Please 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

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: