Note: This article was originally published in 2013. Some steps, commands, or software versions may have changed. Check the current Sharepoint 2013 documentation for the latest information.

In this step-by-step guide, you’ll learn resolve issue . SharePoint 2013 introduced social features, improved search, cross-site publishing, and enhanced mobile browsing experiences.

Prerequisites

Before you begin, make sure you have:

  • SharePoint Server 2013 or later
  • Farm administrator or site collection admin access
  • PowerShell with SharePoint snap-in

How to: Resolve issue “This workbook cannot be opened because it is not stored in a trusted location. To create a trusted location, contact your (http://en.wikipedia.org/wiki/System_administrator “System administrator”).” on (http://sharepoint.microsoft.com “Microsoft SharePoint”) 2013

Right after installing SharePoint 2013 you might run into the issue that when your users try to open an Excel file you run into the (http://en.wikipedia.org/wiki/Error_message “Error message”) “This workbook cannot be opened because it is not stored in a trusted location. To create a trusted location, contact your system administrator.”. This can be easily resolved by adding your Site to the list of trusted locations as indicated below:

  1. Open Central Web Administration
  2. Click on Manage Service Applications
  3. Click on (http://en.wikipedia.org/wiki/Excel_Services “Excel Services”) Application.
  4. Click on “Trusted file locations”
  5. Add your trusted location. You could easily just have http or https so that it accepts almost any site… I would just add my trusted sites (internal sites) to be safe.

(http://img.zemanta.com/zemified_h.png?x-id=02eea99c-3b02-4712-83e9-7bed217d63ae)](http://www.zemanta.com/?px “Enhanced by Zemanta”)

Summary

You’ve successfully learned resolve issue . If you run into any issues, double-check the prerequisites and ensure your Sharepoint 2013 environment is properly configured.