天天看點

Sharepoint 2013 解決重新整理 ExceBe careful. this workbook contains one or more queries that might be unsafe

如何解決重新整理Excel資料的提示  Be careful. this workbook contains one or more queries that might be unsafe

 新加坡的項目,很多時候孤立無援啊。上網很受限制,為了寫這文章,copy了這個幾張圖檔。

Sharepoint 2013 解決重新整理 ExceBe careful. this workbook contains one or more queries that might be unsafe

這個問題是由 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.

Sharepoint 2013 解決重新整理 ExceBe careful. this workbook contains one or more queries that might be unsafe
Sharepoint 2013 解決重新整理 ExceBe careful. this workbook contains one or more queries that might be unsafe

在External Data 下面 把那個 Refresh warning enabled 的鈎去掉。

就可以了

如下圖

Sharepoint 2013 解決重新整理 ExceBe careful. this workbook contains one or more queries that might be unsafe

繼續閱讀