Power Query Background Refresh in Excel: How to Disable It

How-to basics · Updated November 20, 2026

To disable background refresh for a Power Query in Excel for Microsoft 365 on Windows, open Data > Queries & Connections, right-click the query, choose Properties, and clear Enable background refresh on the Usage tab. Click OK; that query will refresh in the foreground, so Excel waits for its refresh to finish before returning control.

What background refresh means

Background refresh lets Excel start a query refresh and then continue allowing you to work while the data connection runs. When it is enabled, the refresh may still be underway after you have clicked Refresh or Refresh All. The query’s results become available when processing finishes, not necessarily the moment the command returns.

With background refresh disabled, Excel waits for that query’s refresh to complete before treating the refresh as finished. Depending on the source and the amount of data, Excel may appear busy or temporarily be less responsive. The setting changes when Excel waits; it does not make the source return data faster, reduce the amount of data fetched, or cancel a refresh.

Power Query is the data import and transformation feature behind Excel’s Get Data tools. A query can bring in data from a file, database, web source, or another supported source, apply steps such as filtering and changing data types, and load its result to a worksheet or the Data Model. Background refresh concerns the execution and timing of a connection refresh, not the transformation steps themselves.

How to turn it off for one query

  1. In Excel, select Data > Queries & Connections to open the task pane.
  2. On the Queries tab, find the query you want to change. Right-click it and choose Properties.
  3. In the properties dialog, open the Usage tab if it is not already selected.
  4. Clear Enable background refresh, then select OK.
  5. Refresh that query once to confirm the change has the expected effect.

Depending on how the query is presented in your Excel build, you may also see it listed as a connection. In the Connections tab of the Queries & Connections pane, right-click the relevant connection and choose Properties. The connection properties dialog has the Usage settings for that connection. If the checkbox is not present, unavailable, or disabled, the connection type or Excel version may not expose the option; see the troubleshooting section below.

The setting is associated with the query’s connection in the workbook. It is not a Power Query Editor transformation, so you do not need to edit or recreate the query’s Applied Steps. Save the workbook after changing the property if you want the choice preserved for later sessions.

What changes when you disable it

After you clear the checkbox, a manual refresh generally keeps Excel occupied until the query finishes. This can be useful when you need a clear sequence: refresh the data, wait for completion, and then inspect or use the updated result. For example, if a worksheet contains a report table that you check immediately after refreshing, foreground refresh makes it less likely that you will mistake the old table contents for the new results while the query is still running.

It can also help when you are coordinating refreshes with later actions. A person who refreshes a query and then copies the output, exports a report, or starts another dependent task may prefer Excel to wait. However, disabling background refresh does not automatically make every other query or workbook action wait in the exact order you expect. Workbooks with several queries, dependencies, or connections can have their own refresh behavior, so check the finished output rather than assuming that one checkbox controls every operation.

The trade-off is that long refreshes are more noticeable. A query that takes several minutes can keep Excel busy for several minutes, and you may be unable to comfortably work in the workbook during that time. If the source is slow or the query processes a large volume of data, turning off background refresh changes the user experience but does not fix the cause of the delay.

Does this disable refresh automatically?

No. Disabling background refresh does not switch off refreshing. You can still use Refresh or Refresh All, and settings such as refreshing data when the workbook opens or refreshing at a scheduled interval are separate options. If a query is set to refresh when the file opens, clearing Enable background refresh does not, by itself, remove that opening-time refresh; it means Excel handles the refresh in the foreground when it runs.

To change opening-time behavior, open the same query or connection Properties dialog and review the Usage options. If you do not want a query to refresh at workbook opening, clear the separate Refresh data when opening the file option, where available. If you do not want periodic refreshes, review any refresh interval setting separately. Read the labels carefully: these options control whether or when a refresh starts, while background refresh controls whether Excel waits for it to finish.

Likewise, clearing the background option does not remove the query, alter its source credentials, delete loaded data, or change its M code. It only changes the refresh behavior for the connection whose properties you edited.

Choosing the right setting for your workbook

Foreground refresh is often a sensible choice for a workbook where accuracy at the moment of use matters more than being able to work during refresh. Examples include a small operational report where someone immediately checks the newest figures, or a workbook used in a repeatable refresh-and-review procedure. Waiting makes the completion point more obvious.

Background refresh may be more convenient when the query takes a while and you want to continue working elsewhere in Excel. It can suit a large import that does not need to be inspected immediately. Keep in mind that while a query is running, its destination may still show the previous results or an incomplete refresh state. Do not treat the continued availability of the worksheet as proof that the data is current.

  • Choose foreground refresh when you want Excel to wait for a particular query to finish before you continue.
  • Keep background refresh on when staying responsive during a long refresh is more useful than waiting in place.
  • If refresh time is the real problem, investigate the source, query steps, amount of data, and network rather than relying on this checkbox to speed it up.
  • For a shared workbook, tell other users what to expect: foreground refresh can make Excel appear busy, while background refresh can mean results arrive after the refresh command returns.

Background refresh versus Power Query preview

A common source of confusion is the word background. The Enable background refresh option for a connection is not the same as the option controlling background downloads for data previews in Power Query. The preview helps you inspect sample data while authoring a query; refreshing a loaded query updates the workbook’s output. Changing a preview-download preference does not necessarily change how a worksheet or Data Model connection refreshes.

There is also a difference between refreshing a query in the Power Query Editor and refreshing its loaded output in Excel. In the editor, you can preview changes to the query. To update the destination in the workbook, use the workbook’s refresh command, such as right-clicking the query in Queries & Connections and choosing Refresh, or using Data > Refresh All. A preview that looks current is not by itself confirmation that every loaded table or connection has been refreshed.

Why the checkbox may be missing or unavailable

The setting is a connection property, so it is not guaranteed to appear for every source, connection, or Excel environment. If you cannot find it, first make sure you opened the query’s or connection’s Properties dialog rather than the Power Query Editor or the query’s Load To options. In the dialog, look for the Usage tab. If the tab or checkbox still does not appear, the particular connection may not support changing background refresh, or your Excel version may expose different controls.

Other practical checks can help:

  • Confirm you are working in the desktop Excel application and not the browser version. Excel for the web does not provide the same full connection-properties interface for changing this setting.
  • Try opening Properties from the Connections tab if the query is not listed as expected under Queries.
  • Check whether the query is a connection-only query, loads to a worksheet table, or loads to the Data Model. The way it appears can affect which context menu you use, even though the setting itself is connection-related.
  • If you use Excel for Mac, look for the equivalent connection properties in your installed version. Power Query capabilities and available controls can differ from Windows; if the option is not exposed, use Excel for Microsoft 365 on Windows to change it.
  • If the option appears but is greyed out, check for an update and verify that you have opened the properties for the intended connection. Some source types do not support background refresh.

Menu labels and dialogs can vary slightly across Excel releases. On Windows Microsoft 365, Queries & Connections is the usual route. Older desktop versions may expose connections through a Data tab Connections command instead. The important point is to open the properties for the actual query connection, not a similarly named setting for previews or workbook calculation.

Ways to address slow refreshes

If a foreground refresh takes too long, turning background refresh back on may make Excel more available while the work continues, but it is only a workaround for the wait. For a lasting improvement, look for avoidable work in the query or at its source. Filtering rows early, selecting only needed columns, and reducing unnecessary transformations can sometimes reduce the amount of data processed. Whether these changes help depends on the source and whether it can perform some work before sending data to Excel.

Also check whether the delay comes from the source service, network connection, authentication, or a large number of separate queries. Refresh one query at a time when diagnosing the workbook, and note which connection is slow. Avoid repeatedly clicking Refresh while a refresh is already running; that can make it harder to tell which operation is still active. If the workbook is used by others, make a copy before changing query design or load settings, especially when the output feeds other reports.

For a process that must use fully updated data, a reliable routine is to refresh, wait for completion, and then verify the expected table or timestamp before exporting or sharing the workbook. Disabling background refresh can make the waiting step explicit, but verification remains useful, particularly when a source fails or returns stale data.

Frequently Asked Questions

Does disabling background refresh make Power Query faster?
No. It makes Excel wait for the refresh instead of letting it continue in the background. The query still depends on the source, network, and amount of data being processed.

Can I turn off background refresh for every query at once?
There is not one universal workbook-wide switch for all Power Query connections in the standard interface. Open Properties for each connection you want to change and clear the setting where it is available.

Will Refresh All still work after I disable it?
Yes. Refresh All can still refresh queries and connections. The changed connection refreshes in the foreground, although a workbook with multiple connections may have different behavior for each one.

Does this stop a query from refreshing when I open the workbook?
No. Refresh-on-open is a separate Usage setting. Clear Refresh data when opening the file as well if you want to stop that automatic refresh, where the option is available.

Why does Excel still seem busy after I turn off background refresh?
That is expected during a long foreground refresh: Excel is waiting for the connection to finish. If the refresh appears stuck, check the source and connection status, and allow time for a large or slow query rather than assuming the checkbox has stopped it.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.