Fix “This workbook cannot be opened because it is not stored in an excel services application trusted location” Error in SharePoint 2010
Problem: Got this error when trying to open an Excel Sheet stored in a SharePoint 2010 document library: “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”.
Solution:
By default, Excel Services allows browser rendering on Workbooks in “Trusted location”. Add your SharePoint library/site/webapp URL to Excel services trusted file location to eliminate this issue. Here is how to create excel services trusted location:
- Navigate to SharePoint 2010 Central Administration site
- Under Application Management, Click on Manage Service applications
- Select “Excel Services Application” and click on “Manage”
- Click on “Trusted File Locations” and then Click on “Add Trusted File Location”
- Enter the URL of your SharePoint web app/site/library and choose “Trust Children”
- Click “OK” to save your configuration changes.
Now, your Excel sheet should render without any issue.
Technet Reference: Manage Excel Services trusted location – https://technet.microsoft.com/en-us/library/ff191194.aspx. It’s also possible to manage trusted locations using PowerShell. Here is the reference: Excel Services cmdlets