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”.

This workbook cannot be opened because it is not stored in an excel services application trusted location

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”
    add excel services trusted location in sharepoint 2010
  • Enter the URL of your SharePoint web app/site/library and choose “Trust Children”
    configure excel services trusted location
  • 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

Salaudeen Rajack

Salaudeen Rajack - Information Technology Expert with Two-decades of hands-on experience, specializing in SharePoint, PowerShell, Microsoft 365, and related products. He has held various positions including SharePoint Architect, Administrator, Developer and consultant, has helped many organizations to implement and optimize SharePoint solutions. Known for his deep technical expertise, He's passionate about sharing the knowledge and insights to help others, through the real-world articles!

Leave a Reply

Your email address will not be published. Required fields are marked *