SharePoint 2013 - Trusted file location Error

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