In Usage, under Refresh control, if the checkbox is cleared for Refresh this connection on Refresh All, you will get a cancellation when you try Refresh All in the Power Pivot window. Right-click a connection and then click Properties. To view connection properties, in Excel, click Data > Queries & Connections to view a list of all connections used in the workbook. If refresh is not allowed on a particular connection, you'll get a cancellation notice when you run Refresh All or attempt to refresh a specific table that uses the connection.

In Excel, you can set connection properties that determine the frequency of data refresh. For example, queries are not shown for data feed imports.Ĭonnection properties that cancel data refresh Queries are not visible for every type of data source. Switch to Query Editor to view the underlying query. To view the query used during data refresh, click Power Pivot > Manage to open the Power Pivot window. You can view, and sometimes modify, the query by viewing table properties in the Power Pivot window. Table properties show queries used in data refreshĭata refresh is simply rerunning the same query that was used to get the data in the first place. Tip: Are you sharing this workbook with other people who might want to refresh data? Help your colleagues avoid data refresh errors by reminding them to request permissions on the data sources providing the data.

Disable excel queries and connections