SharePoint - You do not have permissions to open this file on Excel Services.

Asked By sweety chinnu on 15-Dec-08 01:29 AM
end of post

Is it any setting we have to change to get the permission - sweety chinnu replied to sweety chinnu on 15-Dec-08 01:31 AM

end of post

Re :: You do not have permissions to open this file on excel services

Shailendrasinh Parmar replied to sweety chinnu on 15-Dec-08 01:59 AM

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

Hope this helps.

Re :: You do not have permissions to open this file on Excel Services

Shailendrasinh Parmar replied to sweety chinnu on 15-Dec-08 02:00 AM

Solution:
Open the Shared Services Admin Site
Central Admin > Application Management > Create or Configure this Farm's Shared Services > SSP > Open Shared Services Admin Site
Set the Unattended Service Account
Shared Services Admin > Excel Services Settings > Edit Excel Services Settings > External Data > Unattended Service Account

Hope this helps.

Re :: You do not have permissions to open this file on Excel Services
Shailendrasinh Parmar replied to sweety chinnu on 15-Dec-08 02:03 AM

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.

If you are troubled with the above errors in SharePoint while publishing and viewing the excel services forms in browser then I believe you are in the right place. I am not sure if my guidelines will solve your problem but at least it solved my issues.

1.In central admin site, in operations page, under services in the server farm enable the Excel Services.

2. Open up the Shared Services Admin site. Under “Excel Services settings” section, open the ‘Edit Excel Services settings ‘. Set the File Access Method to Process Account. In the same page under the ‘External Data’ section assign the appropriate user.

3.Back to SSP Admin site. Open the “Excel Services Trusted File Locations”. Give the URL Address of the location where you publish your excel workbooks. Potentially this will be the document library of type excel services. If it’s a document library make sure not to put the complete URL i.e DON’T PUT something like http://server:5050/doclibraryname/Forms/AllItems.aspx, instead put it like http://server:5050/doclibraryname. In my case this is the main reason which showed the above error. If I use full URL I get those errors and no site mentions this after spending hours searching on google.

4.In the same page under the ‘External Data’ select the Trusted data connection libraries and embedded or just the Trusted data connection libraries.

Hope this helps.

Re :: You do not have permissions to open this file on Excel Services
Shailendrasinh Parmar replied to sweety chinnu on 15-Dec-08 02:05 AM

Hello  Sweety Chinnu,

You should check this video. Usefull tutorial to ECS settings:
http://preview.microsoft.com/video/videoDetails.aspx?video=3af80e00-3781-49d8-8236-ed737f0267ce

Plus the Official guide:
http://msdn.microsoft.com/en-us/library/aa972194.aspx

Hope it helps.

read this - C_A P replied to sweety chinnu on 15-Dec-08 04:20 AM
You open a Web page that uses Excel Web Access in Microsoft Office SharePoint Server 2007. If Excel Web Access uses a file from a UNC path that is in a trusted location, the file does not open.
Additionally, you receive this error message: 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.

To work around this issue, use one or more of the following methods, as appropriate for your situation:
  • Make sure that the location type for the trusted location is in UNC format.
  • Make sure that the file access method on the server is set to process account.
  • Make sure that the account that is running Excel Services has permissions to access the UNC share.

try this step - C_A P replied to sweety chinnu on 15-Dec-08 04:24 AM

To fix:

1. In SharePoint Central Administration, go to 'Manage this farm's shared services'

2. Select your shared service. (Default is SharedServices1)

3. In 'Excel Services Settings' select Edit Excel Services settings.

4. Ensure that File Access method is Process Account. Click OK.

5. Back in 'Excel Services Settings' select 'Trusted File Locations'

6. Add a new Trusted file Location:

 > URL: Specigy the report library or the entire portal

 > Location Type: Windows SharePoint Services

 > Children: Trusted