As working
in the support industry, we use to get lot of tickets on daily basis so out of
that we get one ticket today which was based on excel web part error-
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.
From the
above error message, it seems very clear to the SharePoint Administrators/IT experts
who are handling the SharePoint environments/providing support to the
SharePoint Infrastructure.
Let me
explain the resolution step by step so that they would be no confusion but
still in case of any queries/questions then please feel free to contact me so
that I can resolve your issue / guide you in appropriate directions. Thank you.
Resolution:-
1.
Open
the SharePoint 2013 central administration
2.
Application
management
3.
Manage
service applications
4.
Excel
services service application
5.
Click
on it
6.
It
will open ‘manage excel services application page’
7.
Click
on trusted file locations
8.
Add
trusted file location
9.
Inside
the Address filed, enter the document library URL where the excel documents are
stored
10.
Select
children trusted
11.
Keep
all the other values as it if you don’t have any specific requirements
12.
Click
OK
That’s it-
You are done! – Go back to your page where the excel web access webpart was
throwing the error, refresh the page and check the results!
Thank
you. Happy SharePoint to all of you
