sharepoint 2013刷新Excel [英] sharepoint 2013 refresh excel

问题描述

我已经使用共享点列表作为Excel的数据源，并发布了共享点文档库.我已经在Excel工作表中将数据透视表添加为Excel Web Access WebPart.每当我刷新数据时，都会出现以下消息:

I have used share point list as data source excel and published to share point document library. I have added pivot table in the excel sheet as excel web access webpart. Whenever I refresh the data the following messages are coming:

" 是小心.此工作簿包含一个或多个可能不安全的查询.

"Be careful. This workbook contains one or more queries that might be unsafe.Do you want to enable these queries?"

在单击确定"按钮后

出现以下消息吗?

数据连接使用Windows身份验证，因此无法委派用户凭据.以下连接未能刷新:

如何解决.

推荐答案

以下是解决此警告的解决方法

Here is the resolution to fix this warning

https://blogs.technet.microsoft.com/excel_services__powerpivot_for_sharepoint_support_blog/2013/10/22/excel-services-query-warning/

https://blogs.technet.microsoft.com/excel_services__powerpivot_for_sharepoint_support_blog/2013/10/22/excel-services-query-warning/

这篇关于sharepoint 2013刷新Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！