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
|
|
|
TRIAL
DOWNLOAD:Skybot
Scheduler: Modern
IT Job Scheduling Software |
 |
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
|
|
|
|
|
Popular Posts
-
This is the method, I followed to achieve – add image to custom list with calculated / conditional column. Following is the result list...
-
if you want to do a User profile import in SharePoint 2010.. you should have the 'User Profile Synchronization Service' started....
-
SharePoint provides you “Export to Spreadsheet” feature across almost all list, allowing you to export your list content to Excel. But no...
-
Note: A LOT of these questions are specific to SharePoint 2007, and won't have applicability for SharePoint 2003! 1) What are the...
-
A very common & known issue while migrating IE versions. There is couple of steps and checking should be done to get this resolved. ...
-
I found this really great article that talks in depth as well in an easy language about the new options of under look and feel of 2013. h...
-
The April 2015 Cumulative Update for SharePoint 2010 has been released. SharePoint Foundation: https://support.microsoft.com/en-us/kb...
-
We love virtual labs they are free, non hassle and disposable ways to work around SharePoint deployment SharePoint 2010 virtual lab can be...
-
The April 2015 Cumulative Update for SharePoint 2013 has been released. SharePoint Foundation: http://support.microsoft.com/kb/29652...
-
June 2014 Cumulative Update for SharePoint 2013 has been released. SharePoint Foundation - KB2881063 http - //support.microsoft.com/kb...
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.
