SharePoint 2010 Cannot open workbook because it’s not stored in an Excel Services Application trusted location
Chris McKinley | June 22, 2010If you are using the 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.”
If you happen to be the system administrator and you’ve turned to google bing google to find the answer hopefully this blog post will help you out!
I believe this error is most likely if you are going over SSL as the default trusted location is just http://
Jump into central admin (please ignore my heath analyzer!) and goto Manage service applications.
Click on Excel services Application.
Then click on “Trusted file locations”
You can see that http:// is already there, so you could just add https:// or put in a url to a specific location
Fill in the boxes, I also ticked the trust children box.
Once you have done this go back to your Excel document and it will open up in the browser! Nice.
[...] This post was mentioned on Twitter by Planet SharePoint, Dave Coleman, Erik Neumann, Alan Richards, Chris McKinley and others. Chris McKinley said: New Post http://tinyurl.com/34csnzs SP2010 Cannot open workbook because it’s not stored in Excel Services Application trusted location [...]
Great tip for every SharePoint administrator!
[...] SharePoint 2010 Cannot Open Workbook Because It’s Not Stored in an Excel Services Application … (Chris and Daves SharePoint and Tech Blog)If you are using the 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.” [...]
Excellent, thank you very much, worked perfectly on our farm!
We aren’t using SSL, yet we still get this error.