17 March, 2012

When opening an excel file I get the following error "This workbook cannot be opened because it is not stored in an Excel Services Application trusted location.

If you are working on Office Web apps in SharePoint 2010 then you may come across this error…
“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.”

its very simple to resolve this error and start working on excel again :-)
there are 2 methods to resolve this issue:

Option 1: Configure to open in Client Application
At the site collection level activate the "Open Documents in Client Applications by default Feature"

Option2: At the Document Library set the "Opening Documents in the Browser" setting to "Open in client application"

OR
  1. open central admin 
  2. go to Manage service applications
  3. Click on Excel services Application.
  4. Then click on “Trusted file locations”
  5. You can see that http:// is already there, so you could just add https:// or put in a url to a specific location
  6. Fill in the boxes, I also ticked the trust children box.
  7. Once you have done this go back to your Excel document and it will open up in the browser. 
If you have any queries/questions regarding the above mentioned information then please let me know, thank you

1 comment:

  1. You may look at Fix Excel files. It restores *.xls, *,xlt, *.xlsx, xlsm, *.xltm, *.xltx, *.xlam extension of Excel files. Program comes back excel data crashed by hard drive failure, corrupted CD or DVD, errors in transferring the file via the LAN or the Internet.

    ReplyDelete

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.