当前位置: 代码迷 >> .NET新技术 >> SharePoint Excel Refresh error解决办法
  详细解决方案

SharePoint Excel Refresh error解决办法

热度:151   发布时间:2016-04-25 01:41:36.0
SharePoint Excel Refresh error
在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.



------解决方案--------------------
SharePoint听说过,没有使用过,友情帮顶一下子!
------解决方案--------------------
  相关解决方案