18 March, 2012

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


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.

Resolution:
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: Specify the report library or the entire portal

 > Location Type: Windows SharePoint Services

 > Children: Trusted

If you have any queries/questions regarding the above mentioned information then please let me know.
I would be more than happy to help you as well as resolves your issues, thank u

2 comments:

  1. excel fix cell values, their sizes, formulas, font formatting, etc. Utility fixes damaged *.xls, *.xlsx files of all versions of Microsoft Excel. It displays a table with all data that it has recovered in its window. It supports all versions of Windows OS.

    ReplyDelete
  2. Works like a charm! Thanks.

    ReplyDelete

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.