管理 Excel Services 信任檔案位置 (SharePoint Server 2013)Manage Excel Services trusted file locations (SharePoint Server 2013)

摘要:新增、 設定或刪除 SharePoint Server 2013 的 Excel Services 信任的檔案位置。Summary: Add, configure, or delete an Excel Services trusted file location in SharePoint Server 2013.

信任的檔案位置是 SharePoint Server 2013 位置、 網路檔案共用或系統管理員已明確啟用要載入的活頁簿的 Web 資料夾位址。Excel Services 只會從信任的檔案位置載入活頁簿。A trusted file location is a SharePoint Server 2013 location, network file share, or Web folder address that the administrator has explicitly enabled workbooks to be loaded from. Excel Services only loads workbooks from trusted file locations.

使用本文中的程序來設定適用於 Excel Services 信任的檔案位置。Use the procedures in this article to configure trusted file locations for Excel Services.

若要執行這些程序,您必須是伺服器陣列管理員群組或您所設定的 Excel Services 服務應用程式的管理員的成員。To perform these procedures, you must be member of the Farm Administrators group or an Administrator for the Excel Services service application that you are configuring.

重要

本文中的步驟適用於 SharePoint Server 2013 Enterprise 中。The steps in this article apply to SharePoint Server 2013 Enterprise.

新增信任的檔案位置Add a trusted file location

使用下列程序中 Excel Services 新增信任的檔案位置。Use the following procedure to add a trusted file location in Excel Services.

新增信任的檔案位置To add a trusted file location

  1. 按一下 [SharePoint 管理中心網站首頁上,在 [應用程式管理] 區段的 [管理服務應用程式]。On the SharePoint Central Administration website home page, in the Application Management section, click Manage service applications.

  2. 在 [管理服務應用程式] 頁面上按一下 [您想要設定的 Excel Services 服務應用程式]。On the Manage service applications page, click the Excel Services service application that you want to configure.

  3. 在 [管理 Excel Services 應用程式] 頁面上按一下 [信任的檔案位置]。On the Manage Excel Services Application page, click Trusted File Locations.

  4. 在 [Excel Services 應用程式信任的檔案位置] 頁面上按一下 [新增信任的檔案位置]。On the Excel Services Application Trusted File Locations page, click Add Trusted File Location.

  5. 設定信任的檔案位置中所述設定信任的檔案位置] 下方的設定。Configure the settings for the trusted file location as described in Configure a trusted file location, below.

設定信任檔案位置Configure a trusted file location

使用下列步驟設定信任檔案位置。Use the following procedure to configure a trusted file location.

若要設定信任的檔案位置To configure a trusted file location

  1. 按一下 [SharePoint 管理中心網站首頁上,在 [應用程式管理] 區段的 [管理服務應用程式]。On the SharePoint Central Administration website home page, in the Application Management section, click Manage service applications.

  2. 在 [管理服務應用程式] 頁面上按一下 [您想要設定的 Excel Services 服務應用程式]。On the Manage service applications page, click the Excel Services service application that you want to configure.

  3. 在 [管理 Excel Services 應用程式] 頁面上按一下 [信任的檔案位置]。On the Manage Excel Services Application page, click Trusted File Locations.

  4. 在 [位址] 欄中,按一下您想要設定信任的檔案位置。In the Address column, click the trusted file location that you want to configure.

  5. 根據下裱中的描述設定設定項:Configure the settings as described in the following table:

選項Option 描述Description
地址Address
您想要建立信任關係的 Excel Services 的 Excel 文件的位置。The location of the Excel documents that you want Excel Services to trust.
位置類型Location Type
如果文件庫會儲存在 SharePoint Server 2013 內容資料庫中,選取 [ Microsoft SharePoint Foundation]。如果文件庫會儲存在網路檔案共用,選取 [ UNC。如果文件庫會儲存在 Web 資料夾位址中,選取 [ HTTP]。If the document library is stored in the SharePoint Server 2013 content database, select Microsoft SharePoint Foundation. If the document library is stored in a network file share, select UNC. If the document library is stored in a Web folder address, select HTTP.
信任子項Trust Children
選取 [子項信任如果您想要信任所有子文件庫或目錄。Select Children trusted if you want to trust all child libraries or directories.
說明Description
您指定的檔案位置的描述文字。Text description of the file location you specified.
工作階段逾時Session Timeout
Excel Calculation Services 工作階段可以保持開啟且未作用之前的秒數的值是關閉的情況下,從每次開啟要求結束時開始計算。預設值為 450 秒數。Value in seconds that an Excel Calculation Services session can stay open and inactive before it is shut down, as measured from the end of each open request. The default is 450 seconds.
短期工作階段逾時Short Session Timeout
Excel Services 工作階段保持開啟且未作用之前任何使用者介入, 之前關閉, 的秒數的值。這會從原始的開啟要求結束開始計算。預設值為 450 秒數。Value in seconds that an Excel Services session stays open and inactive, before any user interaction, before it is shut down. This is measured from the end of the original open request. The default is 450 seconds.
新活頁簿工作階段逾時New Workbook Session Timeout
新的活頁簿 Excel Calculation Services 工作階段保持開啟且未作用之前的秒數的值已關閉,從每個要求結束時開始計算。預設值為 1800 秒 (30 分鐘)。Value in seconds that an Excel Calculation Services session for a new workbook stays open and inactive before it is shut down, as measured from the end of each request. The default value is 1,800 seconds (30 minutes).
最大要求持續期間Maximum Request Duration
以秒為單位的值,其值為工作階段中單一要求的最長持續時間。預設值為 300 秒。Value in seconds for the maximum duration of a single request in a session. The default is 300 seconds.
轉譯最長持續時間Maximum Chart Render Duration
以秒為單位的值,表示呈現任一圖表所花費的時間上限。預設值為 3 秒。Value in seconds for the maximum time that is spent rendering any single chart. The default is 3 seconds.
最大活頁簿大小Maximum Workbook Size
位元組 (MB) 大小上限的 Excel Calculation Services 可以開啟的活頁簿中的值。預設大小為 10 mb。Value in megabytes (MB) for the maximum size of workbooks that Excel Calculation Services can open. The default size is 10 megabytes.
圖表或影像上限Maximum Chart or Image Size
值 (mb) 大小上限的圖表或 Excel Calculation Services 可以開啟的圖像。預設大小為 1 mb。Value in megabytes (MB) for the maximum size of charts or images that Excel Calculation Services can open. The default size is 1 megabyte.
動態函數快取週期Volatile Function Cache Lifetime
以秒為單位的值,此值為快取動態函數之計算值進行自動重新計算的時間。預設值為 300 秒。Value in seconds that a computed value for a volatile function is cached for automatic recalculations. The default is 300 seconds.
活頁簿計算模式Workbook Calculation Mode
選取要執行所指定的計算檔案中的檔案Select File to perform calculations as specified in the file.
選取 [手動如果希望只在收到計算要求時才進行重新計算。Select Manual if you want recalculation to occur only when a Calculate request is received.
如果您想要使該值而定的其他所有值的重新計算的值的任何變更,請選取自動。此外,動態函數會呼叫如果其逾時已過期。Select Automatic if you want any change to a value to cause the recalculation of all other values that depend on that value. Also, volatile functions are called if their time-out has expired.
如果您想要使其他所有值取決於該值 (的值不能是資料表中的資料) 的重新計算的值的任何變更,選取自動除了資料表格此外,動態函數會呼叫如果其逾時已過期。Select Automatic except data tables if you want any change to a value to cause the recalculations of all other values dependent on that value (the values cannot be in a data table.) Also, volatile functions are called if their time-out has expired.
允許外部資料Allow External Data
選取 [停用所有信任的檔案位置的外部資料連線。Select None to disable all external data connections for the trusted file location.
選取 [信任的資料連線庫僅僅啟用 [使用儲存在信任的資料連線庫中的資料來源的連線。伺服器將略過內嵌在工作表中的設定。Select Trusted data connection libraries only to only enable using connections to data sources that are stored in a trusted data connection library. The server will ignore settings embedded in the worksheet.
選取 [信任的資料連線庫與內嵌連線啟用活頁簿檔案中內嵌的連線或儲存在信任的資料連線庫的連線。如果您不需要有嚴格控制或限制在伺服器上的活頁簿所使用的資料連線,請考慮選取此選項。Select Trusted data connection libraries and embedded to enable connections that are embedded in the workbook file or connections that are stored in a trusted data connection library. If you do not have to have tight control or restrictions on the data connections that are used by workbooks on the server, consider selecting this option.
重新整理時警告Warn on Refresh
選取 [重新整理警告已啟用] 核取方塊以顯示一則警告訊息之前重新整理外部資料中此位置的檔案。當您選取這個選項時,您確定該外部資料不會自動重新整理時不需使用者互動。Select the Refresh warning enabled check box to display a warning before refreshing external data for files in this location. When you select this option, you make sure that external data is not automatically refreshed without user interaction.
顯示細微的外部資料錯誤Display Granular External Data Errors
選取 [外部資料失敗發生在此位置的檔案時顯示特定錯誤訊息的 [細微的外部資料錯誤] 核取方塊。顯示特定錯誤訊息可以協助疑難排解時所發生的資料連線問題。Select the Granular External Data Errors check box to display specific error messages when external data failures occur for files in this location. Displaying specific error messages can help troubleshoot data connectivity issues if they occur.
「開啟時重新整理」失敗時停止Stop When Refresh on Open Fails
選取 [停止開啟已啟用] 核取方塊可防止使用者檢視設定為在開啟、 重新整理重新整理失敗時的檔案。這可防止使用者看不到活頁簿中的快取的資訊。此選項才有效如果使用者的活頁簿上沒有開啟項目權限。(具有的活頁簿上的開啟項目權限的使用者可以在 Excel 中開啟活頁簿與因此有權存取任何快取資訊)。Select the Stopping open enabled check box to prevent users from viewing files that are configured to refresh on open, if the refresh fails. This prevents users from seeing cached information in the workbook. This option is only effective if the user does not have Open Item permissions on the workbook. (A user with Open Item permissions on the workbook can open the workbook in Excel and thus has access to any cached information.)
外部快取週期 (自動重新整理)External Cache Lifetime (Automatic Refresh)
在 [自動重新整理 (定期 / 開啟) ] 方塊中輸入值系統可以使用外部資料查詢結果的自動重新整理外部查詢結果的最長時間 (秒)。預設值為 300 秒。In the Automatic refresh (periodic / on-open) box, type a value in seconds for the maximum time that the system can use external data query results for automatically refreshed external query results. The default is 300 seconds.
外部快取週期 (手動重新整理)External Cache Lifetime (Manual Refresh)
在 [手動重新整理] 方塊中輸入值系統可以使用外部資料查詢結果的手動重新整理外部查詢結果的最長時間 (秒)。若要防止資料重新整理第一次查詢之後,請輸入-1。預設值為 300 秒。In the Manual refresh box, type a value in seconds for the maximum time that the system can use external data query results for manually refreshed external query results. To prevent data refresh after the first query, type -1. The default is 300 seconds.
每一工作階段的最大並行查詢數目Maximum Concurrent Queries Per Session
輸入一個值,此值為單一工作階段中可以同時執行的查詢數上限。預設值為 5 個查詢。Type a value for the maximum number of queries that can run at the same time during a single session. The default is 5 queries.
允許使用 REST 的外部資料Allow External Data Using REST
選取從 REST API 來重新整理外部資料連線的所有要求從功能其餘的資料重新整理] 核取方塊。請注意此設定不會影響如果允許外部資料設定為None。請注意,此設定且不會影響是否啟用重新整理警告。Select the Data refresh from REST enabled check box to all requests from the REST API to refresh external data connections. Note that this setting has no effect if Allow External Data is set to None. Note too, that this setting has no effect if Warn on Refresh is enabled.
允許使用者定義的函數Allow User-Defined Functions
如果您想要允許此位置的活頁簿的 Excel Calculation Services 中的使用者定義的函數] 選取 [允許使用者定義的函數Select User-defined functions allowed if you want to allow user-defined functions in Excel Calculation Services for workbooks from this location.
  1. 按一下 [ OK ]。Click OK.

刪除信任檔案位置Delete a trusted file location

使用下列步驟刪除信任檔案位置。Use the following procedure to delete a trusted file location.

注意

刪除信任的檔案位置不會影響本身的檔案位置或其內容。它只會移除該位置從 [Excel Services 的信任的位置] 清單及 Excel Services 不會再將活頁簿載入從該位置。Deleting a trusted file location does not affect the file location itself or its contents. It only removes the location from the Excel Services trusted location list, and Excel Services no longer loads workbooks from that location.

若要刪除信任的檔案位置To delete a trusted file location

  1. 按一下 [SharePoint 管理中心網站首頁上,在 [應用程式管理] 區段的 [管理服務應用程式]。On the SharePoint Central Administration website home page, in the Application Management section, click Manage service applications.

  2. 在 [管理服務應用程式] 頁面上按一下 [您想要設定的 Excel Services 服務應用程式]。On the Manage service applications page, click the Excel Services service application that you want to configure.

  3. 在 [管理 Excel Services 應用程式] 頁面上按一下 [信任的檔案位置]。On the Manage Excel Services Application page, click Trusted File Locations.

  4. 在 [Excel Services 應用程式信任檔案位置] 頁面上,指向您要刪除、 按一下出現箭號,然後按一下 [刪除的受信任的檔案位置。On the Excel Services Application Trusted File Locations page, point to the trusted file location that you want to delete, click the arrow that appears, and then click Delete.

  5. 按一下 [詢問您是否要刪除的訊息方塊中的[確定]Click OK in the message box that asks whether you want to continue with the deletion.

另請參閱See also

其他資源Other Resources

在 SharePoint 中設定 Excel ServicesConfigure Excel Services in SharePoint