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

FREE Trial Download for IT Job Scheduling Software

Windows IT Pro | Welcome
TRIAL DOWNLOAD:Skybot Scheduler: Modern IT Job Scheduling Software Download this white paper
Efficiency and organization seem to go hand in hand these days. When you are dealing with dozens of network devices, and most of the time simultaneously, it is vital that they are being regulated and ordered.
This is why Modern IT Job Scheduling Software is becoming more important than ever. The more tasks a server needs to handle, the more sophisticated your scheduler should be.
Skybot is offering a free trial download of their scheduling software, which is a perfect opportunity to realize the convenience of organization.
There are plenty of reasons to give this software a try:
  • Out-of-the-box scheduling software
  • SAP task scheduling
  • Built-In auditing
  • and more!
Click HERE for this FREE trial download
Check out Windows IT Pro Resources to see a full listing of available
eBooks, white papers and essential guides.