This workbook contains one or more queries that refresh external data

For Excel workbooks that contain Power Pivot data, Excel Services shows this warning when it detects connection information and prompts you to enable or disable queries for this workbook.


Product Name Power Pivot for SharePoint
Product Version SQL Server 2008 R2, SQL Server 2012, SQL Server 2014
Cause Excel Services is configured to warn on data refresh.
Message Text This workbook contains one or more queries that refresh external data. A malicious user can design a query to access confidential information and distribute it to other users or perform other harmful actions.

If you trust the source of this workbook, click Yes to enable queries to external data in this workbook. If you are not sure, click No so that changes are not applied to your workbook.

Do you want to enable queries to external data in this workbook?


Power Pivot workbooks contain embedded data connection strings that are used by Excel to communicate with an external Power Pivot server that loads and calculates the data. When warn on data refresh is enabled, Excel Services detects this connection string and warns the user accordingly.

To filter and slice Power Pivot data in the workbook, queries must be enabled. Be sure that you enable queries for only those Power Pivot workbooks that you trust.

User Action

Click Yes to enable queries.

You can also change the configuration settings so that warn on refresh no longer occurs:

  1. In Central Administration, in Application Management, click Manage service applications.

  2. Click Excel Services Application.

  3. Click Trusted File Location.

  4. Click http:// or the location you want to configure.

  5. In External Data, clear the checkbox for Warn on data refresh.

  6. Click OK.

    Alternatively, you can create a new trusted location for sites that contain Power Pivot workbooks, and then modify the configuration settings for just that site. For more information, see Create a trusted location for Power Pivot sites in Central Administration.