Monday, June 24, 2013

Cannot open the excel files in Sharepoint 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"



Initially what users do - They contact SP admins and ask them to add library to trusted file location (as error says) but in SP 2010 it's not the case

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

No comments:

Popular Posts

Disclaimer

The opinions expressed on this blog are the personal views of Pratik's SharePoint Blog, and do not represent or reflect the viewpoints or policies of any past, present, or future employer, colleague, or customer, or any other entity. The posts on this blog are provided ‘as is’ with no warranties, express or implied, and confer no rights. Use of information contained within this blog, including specific technical steps mentioned herein, is at your own risk. References to specific software products, processes, resources, or companies do not imply any endorsement.