Showing posts with label This workbook cannot be opened. Show all posts
Showing posts with label This workbook cannot be opened. Show all posts

27 March, 2013

Cannot open the excel files in Sharepoint 2010

Its not a issue actually its just a setting that has changed may be after Migration to 2010.

Issue : Users cannot open excel files in SharePoint 2010 from the Library and get an 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


Normally what we tend to do is we will go to the administrator and ask him to add the library to the trusted location .

Not need . No setting to be made on the server it is just a Library setting which can be changed from the site itself . Until you want to use excel web services ( Please make a note of this )

Cause : By default the files are designed to open in browser . So it is checking for trusted location   

Resolution :  

=> Go to the Library
=> On the top click on Library and go to Library settings .
=> Under General settings you will find Advanced settings 
=> Over there you will find the option which by default is set to open in Browser 
=> you need to set it to Open in Client and there you go . 
=> Click OK and you are done .

Hope it helps and you don't disturb the administrators :)     
 

17 March, 2012

When opening an excel file I get the following error "This workbook cannot be opened because it is not stored in an Excel Services Application trusted location.

If you are working on 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.”

its very simple to resolve this error and start working on excel again :-)
there are 2 methods to resolve this issue:

Option 1: Configure to open in Client Application
At the site collection level activate the "Open Documents in Client Applications by default Feature"

Option2: At the Document Library set the "Opening Documents in the Browser" setting to "Open in client application"

OR
  1. open central admin 
  2. go to Manage service applications
  3. Click on Excel services Application.
  4. Then click on “Trusted file locations”
  5. You can see that http:// is already there, so you could just add https:// or put in a url to a specific location
  6. Fill in the boxes, I also ticked the trust children box.
  7. Once you have done this go back to your Excel document and it will open up in the browser. 
If you have any queries/questions regarding the above mentioned information then please let me know, thank you