如何解决刷新Excel数据的提示 Be careful. this workbook contains one or more queries that might be unsafe
新加坡的项目,很多时候孤立无援啊。上网很受限制,为了写这文章,copy了这个几张图片。
这个问题是由 Excel Services引起的。
打开 SharePoint Central Administration 打开 Application Management 单击 Service Applications open Manage service applications 单击 Excel Services application click Trusted File Locations and click on the Address that contains the workbook.
在External Data 下面 把那个 Refresh warning enabled 的钩去掉。
就可以了
如下图