Chris and Daves SharePoint and Tech Blog

All about SharePoint and Technology
  • rss
  • Home
  • About Dave
  • About Chris
  • Links and Resources

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

Chris McKinley | June 22, 2010

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.

Categories
Office 2010, SharePoint, Sharepoint 2010, WebApps
Tags
Central Admin, Office 2010, SharePoint2010, WebApps
Comments rss
Comments rss
Trackback
Trackback

« Updated SharePoint 2010 in Education Post SUGUK Presentation June 24th 2010 »

5 Responses to “SharePoint 2010 Cannot open workbook because it’s not stored in an Excel Services Application trusted location”

  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 says:
    June 22, 2010 at 12:37 pm

    [...] 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. Danny says:
    June 22, 2010 at 9:47 pm

    Great tip for every SharePoint administrator!

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

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

  4. Joe says:
    July 16, 2010 at 2:14 pm

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

  5. Danny says:
    August 4, 2010 at 12:22 pm

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

Leave a Reply

Click here to cancel reply.

SharePoint Products

Sponsor

ShareNews, ShareEvents, ShareIdeas, ShareCV or ShareCoffee
Powered by Postrank

Tags

  • Active Directory Analytics BCS BETT BETT 2010 branding Case Study Central Admin Cognitive Community CSS DHCP DocIcon Drop Folder Evolution Exchange 2007 Exchange 2010 Exchange Service Pack 1 Expression blend FAST Forefront Gmail GodMode Google HyperV IC Technology IE9 Knowledge base Learning Gateway Conference LGCUK10 Licencing master page MDT Media Streaming Microsoft Migration Mind Manager Monitoring Tools Office 2010 Outlook 2010 pdf PowerPoint PowerPoint 2010 Powershell RDP Revision RTM SCVMM Server 2008 R2 SharePoint Sharepoint 2010 SharePoint Conference Sharepoint Designer SharePoint EDU SharePoint Foundation 2010 SharePoint Saturday SharePoint2010 SharePoint2010; Social SketchFlow SPD SPEDU SPS SPSUK SQL SQL 2008 STSADM SUGUK Supplier TechDays Themes Topologies Twynham Versions VHD Volcano WebApps WebParts Windows 7 Windows Live Windows Update Word 2010 WordPress XML XML-RPC XSLT Zevenseas

Categories

Blogroll

  • Alan Richards
  • Alex Pearce's SharePoint Blog
  • Brandon & George
  • End User SharePoint
  • Get The Point
  • Meet Dux
  • Planet SharePoint
  • SharePoint Comic
  • SharePoint Dev Wiki
  • SharePoint In Education
  • SharePoint Joel
  • The SharePoint Mechanic
  • Top SharePoint Sites
  • We Know Nothing

Ads by Lake Quincy Media

rss Comments rss valid xhtml 1.1 design by jide powered by Wordpress get firefox