The data connection file .odc used in the workbook is not in a trusted location in Share point

The data connection file .odc used in the workbook is not in a trusted location in Share point.

Issue -The issue was like while opening excel report which were connected to external connection files

below error was coming while refeshing the Reports.

Solution-

In order to fix this error in Share point site add the doc library in Trusted Data connection libraries in Share point Central Administrator.

for eg you have a data connection lib with URL

http:demo\test\Dataconnection 

and you are all the connection files .ODC are stored in the above doc library which you are using in your excel reports, so in order to fix the above issues 

follow the below steps.

GO to SP -Central admin

-Application Managment

-Service Applications

-Manage Service Applications

-Excel Service Application

Add your Data connection doc lib url in two Places

Trusted File Location-Add-http:demo\test\Dataconnection

Trusted Data connection Libraries-Add-http:demo\test\Dataconnection

check box-Children trusted.

After that refresh the Report and report were working fine.