This workbook contains one or more queries that refresh external data.
For Excel workbooks that contain PowerPivot data, Excel Services shows this warning when it detects connection information and prompts you to enable or disable queries for this workbook.
Details
Product Name |
PowerPivot for SharePoint |
Product Version |
SQL Server 2008 R2, SQL Server 2012 |
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? |
Explanation
PowerPivot workbooks contain embedded data connection strings that are used by Excel to communicate with an external PowerPivot 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 PowerPivot data in the workbook, queries must be enabled. Be sure that you enable queries for only those PowerPivot 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:
In Central Administration, in Application Management, click Manage service applications.
Click Excel Services Application.
Click Trusted File Location.
Click http:// or the location you want to configure.
In External Data, clear the checkbox for Warn on data refresh.
Click OK.
Alternatively, you can create a new trusted location for sites that contain PowerPivot workbooks, and then modify the configuration settings for just that site. For more information, see Create a trusted location for PowerPivot sites in Central Administration.