Option |
Description |
Address |
The location of the Excel documents that you want Excel Services to trust. |
Location Type |
If the document library is stored in the SharePoint Foundation 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 |
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 |
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 |
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 |
Value in seconds for the maximum duration of a single request in a session. The default is 300 seconds. |
Maximum Chart Render Duration |
Value in seconds for the maximum time that is spent rendering any single chart. The default is 3 seconds. |
Maximum Workbook Size |
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 |
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 |
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 |
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) |
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) |
In the "Manual refresh" 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. To prevent data refresh after the first query, type v"-1". The default is 300 seconds. |
Maximum Concurrent Queries Per Session |
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. |
Allow External Data Using REST |
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 |
Select "User-defined functions allowed" if you want to allow user-defined functions in Excel Calculation Services for workbooks from this location. |