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.”
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.
You may also be interested in reading:
- SharePoint 2010 Document Library open Office Documents in browser If you have web apps set up on SharePoint 2010...
- SharePoint 2010 Powershell Commands Help Yesterday i did a post The first steps to SharePoint...
- Easy Access To STSADM Hands up who is fed up with navigating to “c:\program...
- Changes in SharePoint 2010 RTM Web Apps Previously I posted about where’s the save in the SharePoint...
- Migrating from SharePoint 2007 to SharePoint 2010 Last week the twitter community and blogosphere came alive with...
- The First Post Myself and Chris McKinley have been posting the occasional...
22 comments
4 pings
Danny
June 22, 2010 at 9:47 pm (UTC 1) Link to this comment
Great tip for every SharePoint administrator!
Joe
July 16, 2010 at 2:14 pm (UTC 1) Link to this comment
Excellent, thank you very much, worked perfectly on our farm!
Danny
August 4, 2010 at 12:22 pm (UTC 1) Link to this comment
We aren’t using SSL, yet we still get this error.
fcorbeil
October 13, 2010 at 5:56 pm (UTC 1) Link to this comment
Thank you for the solution!
Rahul
December 17, 2010 at 7:41 am (UTC 1) Link to this comment
The topic you have chosen for a blog is very commenting. Good package. Thanks for your effort.
http://godwinsblog.cdtech.in/2010/12/sharepoint-2010-root-of-certificate.html
Anna
January 31, 2011 at 4:01 pm (UTC 1) Link to this comment
It works! Thanks for the post!
Dave Coleman
January 31, 2011 at 4:45 pm (UTC 1) Link to this comment
No problem glad it works for you.
Dave
Lyle Epstein
February 7, 2011 at 3:47 pm (UTC 1) Link to this comment
Thanks Dave, that worked perfectly for me. I will have to add your site to my RSS feeds.
Maclain
February 25, 2011 at 9:45 pm (UTC 1) Link to this comment
Thanks, this worked.
Dilip
April 8, 2011 at 9:58 pm (UTC 1) Link to this comment
Thanks. It worked and our site is a https:\\ site. I wish SharePoint could prompt the user to save it before opening it. Excel services for non-published spreadsheets.
steve
April 9, 2011 at 12:37 am (UTC 1) Link to this comment
Fyi, you can also get this issue simply by accessing sharepoint through Firefox. Try using IE first.
Anony Mouse
April 13, 2011 at 8:07 pm (UTC 1) Link to this comment
Thanks, this worked like a charm. We are using SSL only on our Sharepoint 2010 website.
No problems accessing it via Firefox or IE!
Dheera
May 11, 2011 at 6:59 pm (UTC 1) Link to this comment
Thanks very much!!!!!!!
Dave Coleman
May 11, 2011 at 8:34 pm (UTC 1) Link to this comment
No problem glad the post helped
Dave
Rick
July 8, 2011 at 8:47 pm (UTC 1) Link to this comment
Dave’s suggestion didn’t work for me, so a little further googling found this different cause for the same message.
http://blog.brainlitter.com/archive/2010/05/26/sharepoint-2010-this-workbook-cannot-be-opened-because-it-is-not-stored-in-an-excel-services-application-trusted-location.aspx
This worked for me.
Dave Coleman
July 9, 2011 at 2:04 am (UTC 1) Link to this comment
Thanks for sharing the link Rick always good to know
brett
October 6, 2011 at 4:06 am (UTC 1) Link to this comment
google bing google! great
Moazzam
October 19, 2011 at 2:49 am (UTC 1) Link to this comment
Thanks a lot.
Brilliant.
followed the steps and done.
Kathy Schlauger
December 21, 2011 at 6:29 pm (UTC 1) Link to this comment
Thanks so much – that saved a bunch of time in researching the problem!!
Moazzam
January 31, 2012 at 1:11 am (UTC 1) Link to this comment
Thanks heaps
Yes it works, and i also made it same as the default http://
which included maximum file size limits, timeouts, external data load and user defined formulas to be executed.
so make it same as the default.
Great. Thanks.
Sharepoint 2010 SP1.
Dan
February 13, 2012 at 2:43 pm (UTC 1) Link to this comment
Thx for this; big time saver….
Ed
February 25, 2012 at 4:24 am (UTC 1) Link to this comment
Just what I needed! Thank you!!
Tweets that mention Chris and Daves SharePoint and Tech Blog » SharePoint 2010 Cannot open workbook because it’s not stored in an Excel Services Application trusted location -- Topsy.com
June 22, 2010 at 12:37 pm (UTC 1) Link to this comment
[...] 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 [...]
Steve Ballmer is a God; Why Google Won't Beat Microsoft in Cloud Collaboration; Adobe Brings Flash to Mobiles - SharePoint Daily - Bamboo Nation
June 23, 2010 at 2:32 pm (UTC 1) Link to this comment
[...] 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.” [...]
Problems with SharePoint Webapps - The Windows Phone Guy
February 3, 2011 at 10:16 am (UTC 1) Link to this comment
[...] after a quick search I found myself at SharepointEduTech, which had exactly the solution for my [...]
Cheap Web Design
January 17, 2012 at 6:28 pm (UTC 1) Link to this comment
Websites worth visiting…
[...]here are some links to sites that we link to because we think they are worth visiting[...]……