«

»

Jun 22

SharePoint 2010 Cannot open workbook because it’s not stored in an Excel Services Application trusted location

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.

About Chris McKinley

Chris McKinley has written 26 post on this blog.


Technorati Tags: , , , ,

You may also be interested in reading:

  1. SharePoint 2010 Document Library open Office Documents in browser If you have web apps set up on SharePoint 2010...
  2. SharePoint 2010 Powershell Commands Help Yesterday i did a post The first steps to SharePoint...
  3. Easy Access To STSADM Hands up who is fed up with navigating to “c:\program...
  4. Changes in SharePoint 2010 RTM Web Apps Previously I posted about where’s the save in the SharePoint...
  5. Migrating from SharePoint 2007 to SharePoint 2010 Last week the twitter community and blogosphere came alive with...
  6. The First Post   Myself and Chris McKinley have been posting the occasional...

22 comments

4 pings

  1. Danny

    Great tip for every SharePoint administrator!

  2. Joe

    Excellent, thank you very much, worked perfectly on our farm!

  3. Danny

    We aren’t using SSL, yet we still get this error.

  4. fcorbeil

    Thank you for the solution!

  5. Rahul

    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

  6. Anna

    It works! Thanks for the post!

  7. Dave Coleman

    No problem glad it works for you.

    Dave

  8. Lyle Epstein

    Thanks Dave, that worked perfectly for me. I will have to add your site to my RSS feeds.

  9. Maclain

    Thanks, this worked.

  10. Dilip

    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.

  11. steve

    Fyi, you can also get this issue simply by accessing sharepoint through Firefox. Try using IE first.

  12. Anony Mouse

    Thanks, this worked like a charm. We are using SSL only on our Sharepoint 2010 website.

    No problems accessing it via Firefox or IE!

  13. Dheera

    Thanks very much!!!!!!!

  14. Dave Coleman

    No problem glad the post helped

    Dave

  15. Rick

    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.

  16. Dave Coleman

    Thanks for sharing the link Rick always good to know

  17. brett

    google bing google! great

  18. Moazzam

    Thanks a lot.

    Brilliant.

    followed the steps and done.

  19. Kathy Schlauger

    Thanks so much – that saved a bunch of time in researching the problem!!

  20. Moazzam

    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.

  21. Dan

    Thx for this; big time saver….

  22. Ed

    Just what I needed! Thank you!!

  1. 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

    [...] 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 [...]

  2. Steve Ballmer is a God; Why Google Won't Beat Microsoft in Cloud Collaboration; Adobe Brings Flash to Mobiles - SharePoint Daily - Bamboo Nation

    [...] 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.” [...]

  3. Problems with SharePoint Webapps - The Windows Phone Guy

    [...] after a quick search I found myself at SharepointEduTech, which had exactly the solution for my [...]

  4. Cheap Web Design

    Websites worth visiting…

    [...]here are some links to sites that we link to because we think they are worth visiting[...]……

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>