Tuesday 2 December 2014

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

I just came across one of my clients excel issue. When she is trying to open excel file by clicking on it, getting "This workbook cannot be opened because it is not stored in an Excel Services Application trusted location" error. This generally happens if given site is not added as a trusted site in SharePoint central administration. Please go to the central administrations and do the steps mentioned below:

  1. Open Central Web Administration
  2. Click on Manage Service Applications
  3. Click on Excel services Application.
  4. Click on “Trusted file locations”
  5. Add Trusted file
    1. Address textbox write http://
    2. Check Children trusted box under Trust Children
    3. Check User-defined functions allowed under Allow User-Defined Functions
  6. Repeat step 5 with address as https://(I would like to mention here that all their sites are secured(https))

Above steps resolved my issue successfully. Please post queries or comments, if any.

No comments:

Post a Comment

Pages

Followers