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.
Related posts:
- 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...
20 comments
4 pings
Danny says:
June 22, 2010 at 9:47 pm (UTC 0 )
Great tip for every SharePoint administrator!
Joe says:
July 16, 2010 at 2:14 pm (UTC 0 )
Excellent, thank you very much, worked perfectly on our farm!
Danny says:
August 4, 2010 at 12:22 pm (UTC 0 )
We aren’t using SSL, yet we still get this error.
fcorbeil says:
October 13, 2010 at 5:56 pm (UTC 0 )
Thank you for the solution!
Rahul says:
December 17, 2010 at 7:41 am (UTC 0 )
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 says:
January 31, 2011 at 4:01 pm (UTC 0 )
It works! Thanks for the post!
Dave Coleman says:
January 31, 2011 at 4:45 pm (UTC 0 )
No problem glad it works for you.
Dave
Lyle Epstein says:
February 7, 2011 at 3:47 pm (UTC 0 )
Thanks Dave, that worked perfectly for me. I will have to add your site to my RSS feeds.
Maclain says:
February 25, 2011 at 9:45 pm (UTC 0 )
Thanks, this worked.
Dilip says:
April 8, 2011 at 9:58 pm (UTC 0 )
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 says:
April 9, 2011 at 12:37 am (UTC 0 )
Fyi, you can also get this issue simply by accessing sharepoint through Firefox. Try using IE first.
Anony Mouse says:
April 13, 2011 at 8:07 pm (UTC 0 )
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 says:
May 11, 2011 at 6:59 pm (UTC 0 )
Thanks very much!!!!!!!
Dave Coleman says:
May 11, 2011 at 8:34 pm (UTC 0 )
No problem glad the post helped
Dave
Rick says:
July 8, 2011 at 8:47 pm (UTC 0 )
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 says:
July 9, 2011 at 2:04 am (UTC 0 )
Thanks for sharing the link Rick always good to know
brett says:
October 6, 2011 at 4:06 am (UTC 0 )
google bing google! great
Moazzam says:
October 19, 2011 at 2:49 am (UTC 0 )
Thanks a lot.
Brilliant.
followed the steps and done.
Kathy Schlauger says:
December 21, 2011 at 6:29 pm (UTC 0 )
Thanks so much – that saved a bunch of time in researching the problem!!
Moazzam says:
January 31, 2012 at 1:11 am (UTC 0 )
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.
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 says:
June 22, 2010 at 12:37 pm (UTC 0 )
[...] 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 says:
June 23, 2010 at 2:32 pm (UTC 0 )
[...] 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 says:
February 3, 2011 at 10:16 am (UTC 0 )
[...] after a quick search I found myself at SharepointEduTech, which had exactly the solution for my [...]
Cheap Web Design says:
January 17, 2012 at 6:28 pm (UTC 0 )
Websites worth visiting…
[...]here are some links to sites that we link to because we think they are worth visiting[...]……