Export (0) Print
Expand All

Manage Excel Services trusted file locations (SharePoint Server 2013)

SharePoint 2013
 

Applies to: SharePoint Server 2013

Topic Last Modified: 2014-07-08

Summary: Add, configure, or delete an Excel Services trusted file location by using the SharePoint Central Administration website.

A trusted file location is a SharePoint Server 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.

Use the procedures in this article to configure trusted file locations for Excel Services.

ImportantImportant:
The steps in this article apply to SharePoint Server 2013 Enterprise.

In this article:

Before you configure Excel Services trusted file locations, we recommend that you review Plan Trusted File Locations in SharePoint Server 2013.

NoteNote:
Because SharePoint 2013 runs as websites in Internet Information Services (IIS), administrators and users depend on the accessibility features that browsers provide. SharePoint 2013 supports the accessibility features of supported browsers. For more information, see the following resources:

Before you begin this operation, review the following information about prerequisites:

  • 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.

Use the following procedure to add a trusted file location in Excel Services.

To add a trusted file location
  1. On the SharePoint Central Administration website home page, in the Application Management section, click Manage service applications.

  2. On the Manage service applications page, click the Excel Services service application that you want to configure.

  3. On the Manage Excel Services Application page, click Trusted File Locations.

  4. 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.

Use the following procedure to configure a trusted file location.

To configure a trusted file location
  1. On the SharePoint Central Administration website home page, in the Application Management section, click Manage service applications.

  2. On the Manage service applications page, click the Excel Services service application that you want to configure.

  3. 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

    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 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

    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.

  6. Click OK.

Use the following procedure to delete a trusted file location.

NoteNote:
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. On the SharePoint Central Administration website home page, in the Application Management section, click Manage service applications.

  2. On the Manage service applications page, click the Excel Services service application that you want to configure.

  3. On the Manage Excel Services Application page, click Trusted File Locations.

  4. 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft