Excel Power Query Stop Auto Refresh? Fix It

Errors & fixes · Updated November 22, 2026

Yes, you can stop Power Query from auto-refreshing in Excel by disabling background refresh in the query’s properties, or by turning off the workbook’s refresh settings in Data > Queries & Connections. The most common cause of unwanted automatic refreshes is the “Refresh data when opening the file” option, which is enabled by default for queries loaded to a worksheet or data model.

Why Power Query Refreshes Automatically

Power Query is designed to keep your data current. When you load a query, Excel stores the connection and applies default refresh behaviors. These defaults exist so that when you open a workbook, the data is not stale. However, this can be a problem if you work with large datasets, slow sources, or if you simply want to control when data updates.

There are three main triggers for automatic refresh:

  • Opening the workbook: Excel refreshes all queries that have “Refresh data when opening the file” checked.
  • Periodic refresh: Queries can be set to refresh every X minutes while the workbook is open.
  • Background refresh: When a query runs, it may run in the background, allowing you to continue working. This is not an automatic trigger, but it can make refreshes seem spontaneous.

Additionally, if you have a PivotTable or chart connected to the query, Excel may refresh the query when you change filters or slicers, depending on the PivotTable options.

How to Disable Auto Refresh for a Single Query

To stop a specific query from refreshing when the file opens, follow these steps:

  1. Go to the Data tab and click Queries & Connections (or right-click the query in the Queries pane).
  2. In the Queries & Connections pane, right-click the query name and select Properties.
  3. In the Query Properties dialog, go to the Usage tab.
  4. Under Refresh control, uncheck Refresh data when opening the file.
  5. Also uncheck Refresh data after a specific number of minutes if it is checked.
  6. Click OK.

For Excel for the web, the Properties dialog is not available; you can only disable refresh by using the Data > Queries & Connections pane and selecting “Don’t refresh” from the context menu, but this is limited. On Mac, the steps are the same as Windows in Excel 365, but the dialog may look slightly different.

Disable Auto Refresh for All Queries in a Workbook

If you want to turn off automatic refresh for every query at once, you can change a workbook-level setting:

  1. Go to Data > Queries & Connections.
  2. In the pane, click the Queries tab (the list of queries).
  3. Click the Refresh All dropdown arrow (next to the Refresh All button on the Data tab).
  4. Select Connection Properties (or go to Data > Connections > Properties).
  5. In the Connection Properties dialog, uncheck Refresh data when opening the file and Enable background refresh if you want to prevent background refreshes.

Note: The Connection Properties dialog applies to the selected connection, not all. To apply to all, you may need to select each connection. A quicker way is to use VBA to loop through all connections and set the refresh settings, but that is beyond manual steps.

Common Misconception: Turning Off Auto Refresh vs. Disabling the Query

A frequent mistake is to delete the query or disconnect it, which removes the data table. That is not the same as stopping auto-refresh. Disabling auto-refresh keeps the data as a static snapshot. The query still exists and can be manually refreshed later. If you want to completely stop the query from running, you can unload it (right-click > Unload) but then the data is gone. So choose the right approach:

  • Stop auto-refresh – keeps the current data, but no automatic updates.
  • Unload the query – removes the data table and the query from the workbook, but the connection remains in the workbook’s connection list.
  • Delete the connection – removes everything, but you lose the ability to refresh.

How to Manually Refresh After Disabling Auto Refresh

Once auto-refresh is off, you can still refresh the data manually whenever you need. Use any of these methods:

  • Go to Data > Refresh All to refresh every query.
  • Right-click a query in the Queries & Connections pane and select Refresh.
  • Use the keyboard shortcut Ctrl+Alt+F5 (Windows) or Cmd+Option+F5 (Mac) to refresh all.
  • Use Ctrl+F5 (Windows) or Cmd+R (Mac) to refresh the selected query.

What About Background Refresh?

Background refresh is a separate setting that controls whether a refresh runs in the background (allowing you to keep working) or in the foreground (blocking you until it finishes). It does not by itself trigger a refresh, but it can make a refresh appear to happen on its own if you have a scheduled refresh. To disable background refresh:

  1. Open the Query Properties dialog (as above).
  2. On the Usage tab, uncheck Enable background refresh.

With background refresh off, any manual or automatic refresh will run synchronously, meaning Excel waits until the refresh completes before you can interact. This can be useful for debugging but may slow down your work.

Frequently Asked Questions

Why does my Power Query refresh even after I uncheck the box?

If you unchecked “Refresh data when opening the file” but the query still refreshes on open, check if the PivotTable connected to the query has its own refresh option. Right-click the PivotTable > PivotTable Options > Data tab, and uncheck “Refresh data when opening the file”. Also, if the query is loaded to the Data Model, the connection may have a separate refresh setting under Data > Connections.

Can I stop auto refresh for only a few queries but keep others auto-refreshing?

Yes, the Query Properties dialog is per-query. You can uncheck the auto-refresh box for specific queries and leave it checked for others. There is no global toggle that applies to all except by editing each query’s properties individually.

Is there a way to set a default so new queries never auto-refresh?

No, there is no built-in default to disable auto-refresh for all future queries. You must change the property for each new query. However, you can create a template workbook with the setting disabled and save it as a .xltx file, then use that template for new workbooks.

Does disabling auto refresh affect the data in pivot tables?

It stops the query from refreshing, but the pivot table itself may still refresh its cache when you change filters if the pivot table is set to refresh on filter changes. To prevent that, go to PivotTable Options > Data tab and uncheck “Refresh data when opening the file” and also uncheck “Refresh this connection on Open” if present. The pivot table will still show the last loaded data.

What if I want to stop refresh but keep the data editable?

If you unload the query, the data becomes static and editable. But if you simply disable auto-refresh, the data remains as a table that is still connected to the query. You can convert the table to a range (Table Design > Convert to Range) to break the connection, but then you lose the query. A better approach is to copy the data and paste as values, then remove the query.

Alternatives: Using VBA to Control Refresh

If you need to manage many queries or want to automate the disabling, you can use a simple VBA macro. For example, to disable auto-refresh for all connections in the workbook:

Sub DisableAutoRefresh()
    Dim conn As WorkbookConnection
    For Each conn In ThisWorkbook.Connections
        conn.RefreshOnFileOpen = False
    Next conn
End Sub

Before running any macro, save a copy of your workbook because macros cannot be undone with Ctrl+Z. This code loops through every connection and sets the RefreshOnFileOpen property to False. You can also set conn.BackgroundQuery = False to disable background refresh.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.