在SharePoint excel service application上面点击refresh的button的时候，有个出错信息“Access was denied by the external data source.The following connections failed to refresh: ......"”。
step 1:
In "Central Administration"> "Manage service applications",click the excel service application, click "Trusted File Locations",click "Add Trusted File Location ".
Address : http://
Trust Children select "Children trusted"
Maximum Workbook Size "2000"
Maximum Chart or Image Size "50"
Allow External Data Select " Trusted data connection libraries and embedded"
Warn on Refresh Unselect "Refresh warning enabled"
Allow External Data Using REST select "Data refresh from REST enabled"
Allow User-Defined Functions select "User-defined functions allowed"
click "OK"
If the solution 1 cannot resolve this problem. You can try step 2.
step 2:
In the excel connection proterty, change the authentication type. But you need use Secure Store Service to create account to refresh this excel.