Hello Guys,
If you receive the following Exception when you try to open the sample workbook or another workbook try the following steps:
You do not have permissions to open this file on Excel Services.Make sure that the file is in an Excel Services trusted location and that you have access to the file.
1.Open Central Administration -> go to Operations tab -Ensure that the Excel Service is running.
2.Open Central Administration -> go to your configured Shared Service -> click Excel Service Settings.
-File Access Method: ensure that it is not using Impersonation, instead the Option Process Account should be enabled.
3. Open Central Administration -> go to your configured Shared Service -> click add new trusted file location
-Field URL: here you can specify a report library or the whole portal
-Location Type: should be Windows SharePoint Services
-Children trusted: defines whether the children should also be trusted or only the definied path
If you receive the following Exception when you try to open the sample workbook or another workbook try the following steps:
You do not have permissions to open this file on Excel Services.Make sure that the file is in an Excel Services trusted location and that you have access to the file.
1.Open Central Administration -> go to Operations tab -Ensure that the Excel Service is running.
2.Open Central Administration -> go to your configured Shared Service -> click Excel Service Settings.
-File Access Method: ensure that it is not using Impersonation, instead the Option Process Account should be enabled.
3. Open Central Administration -> go to your configured Shared Service -> click add new trusted file location
-Field URL: here you can specify a report library or the whole portal
-Location Type: should be Windows SharePoint Services
-Children trusted: defines whether the children should also be trusted or only the definied path
Hi Amol
ReplyDeleteDo you know of any restoring issues with SharePoint 2010. I'm unable to do a granular restore of Excel Services Application. Any best practices/idea??
Thanks in advance.
Varun
All Excel Services Application settings will support backup and recovery regardless of whether there is a UI setting in the Central Administration Web site. This means that all global settings, trusted locations, user-defined-functions, data connection libraries, and trusted data provider settings will support backup and recovery. However, the following items will not be backed up as part of the backup and recovery process:
ReplyDeleteUser-defined function assemblies. These assemblies will not be backed up or restored because they are binary files and not simply settings; however, the data in the list of trusted user-defined functions is backed up.
Trusted data provider binaries. The full list of trusted data providers and all associated properties, however, are backed up.
Any Excel Web Access (EWA) Web Part properties.
Office data connection (.odc extension) files and workbook files.
In addition to using Windows PowerShell for Excel Services Application backup and recovery functionality, you can use Windows PowerShell to provision the service application from scratch or provision a new instance that uses settings from a previous backup, and manage and configure trusted file locations, data providers, data connection libraries, and settings for user-defined function assemblies. You can also change global settings for Excel Services Application
please refer the requested article as mentioned below:
Best Practices:http://msdn.microsoft.com/en-us/library/ms545631.aspx
For SharePoint 2010:
ReplyDeleteI encounted this exact problem and after trying countless suggestions, I finally found the solution:
Open IIS manager > Open the web app where the document resides > IIS > Authentication > Disable ASP.NET Impersonation.
Thank you for sharing this valuable info! this will definitely useful for all the users...
Delete