SharePoint Excel Refresh error

Issue

在SharePoint excel service application上面点击refresh的button的时候，有个出错信息“Access was denied by the external data source.The following connections failed to refresh: **********"”。

Workaround / Solution

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.