To enable background refresh in Excel for Microsoft 365 on Windows, open Data > Queries & Connections, right-click the query, choose Properties, and select Enable background refresh on the Usage tab if the option is available. This lets Excel return control while the query refreshes; it does not make the refresh faster or keep it running after Excel is closed.
What background refresh means
A Power Query refresh retrieves data from its source, applies the query’s transformation steps, and updates the query’s destination in the workbook. With background refresh enabled, Excel can let that work continue while you use other parts of the application. You may be able to edit another worksheet, inspect a different query, or continue working while the refresh runs.
With background refresh turned off, Excel generally waits for that connection’s refresh to finish before returning control. This can be useful when you need to know that refreshed results are ready before you take the next step, but it can make Excel feel unresponsive during a long refresh.
The setting concerns how Excel handles the refresh operation, not the query’s logic. It does not change the source, transformation steps, output location, or credentials, and it does not guarantee that a refresh will succeed. A query can still take the same time or fail because a source is unavailable, credentials have expired, or a transformation encounters unexpected data.
How to turn it on in Excel for Windows
- Open the workbook in the Excel desktop app and select the Data tab.
- Choose Queries & Connections to open the pane if it is not already visible.
- On the Queries tab, right-click the query you want to change and choose Properties. You can also open the properties for a connection from the Connections tab, where available.
- On the Usage tab, select Enable background refresh, then choose OK.
- Refresh the query and check its status in the Queries & Connections pane or on the worksheet to confirm that it is still running or has completed.
The exact dialog options can vary by query, source, and how the results are loaded. If the checkbox is missing or unavailable, it may not be supported for that connection or destination. Do not assume that a similarly named option in Power Query Editor controls the same thing; preview settings are separate.
To refresh one query, right-click it in Queries & Connections and choose Refresh. To refresh workbook connections together, use Data > Refresh All. Background refresh is a per-connection property, so check the properties of the particular query whose behavior you want to change.
What changes during a refresh
When background refresh is enabled, Excel can give you back the interface before the query has finished. That is a responsiveness change, not an indication that the new data is already available. Until the refresh completes, the table or connection may still show its previous results. Wait for the refresh status to finish before relying on the updated output, exporting it, or using it in a downstream task.
For example, imagine a query that imports a large monthly sales file and loads it to a worksheet table. You can turn on background refresh and continue reviewing a separate sheet while Excel processes the file. If you immediately copy totals from the table, however, you could copy last month’s results because the refresh may still be underway. Confirm completion first.
Background refresh also does not mean that Power Query runs on a schedule in the cloud. Excel must be open and able to reach the relevant source for a refresh to run. Closing the workbook or quitting Excel is not a way to leave a refresh running unattended. For scheduled, centrally managed refreshes, a service or automation solution may be more appropriate, depending on the data source and organization’s setup.
When to enable it—and when not to
Background refresh is usually helpful for slow imports when you want to keep working in Excel. It is less important for a small local file that refreshes almost instantly. Consider how the workbook is used and whether the next action depends on the newly loaded results.
- Enable it when a large query takes time and you need to work on unrelated sheets or review other workbook content while it runs.
- Leave it off when users should wait for the results before continuing, or when a repeatable process depends on knowing that each refresh has completed before proceeding.
- Test either setting for workbooks with several connected queries, especially if people use Refresh All and expect a particular sequence of actions.
Turning background refresh off is not a general fix for a slow query. It changes whether Excel waits, not how much data the query reads or how many transformations it performs. To improve refresh time, investigate the source size, the steps in the query, network access, and whether the source can do some filtering or calculation before returning data.
Background refresh and Refresh All
Refresh All requests updates for multiple connections in the workbook. If individual connections can refresh in the background, Excel may return control while one or more are still processing. Therefore, the fact that you clicked Refresh All does not by itself prove that every query has finished.
Power Query can also contain references and dependencies: one query may use another query as its source. Excel’s refresh behavior has to account for those relationships, but users should still check the status of the relevant output rather than assume that all work is complete the moment the command returns. If a workbook feeds a report or a manual copy-and-paste workflow, make completion a deliberate checkpoint.
When troubleshooting, refresh a single query first. This helps identify which source or transformation is taking time or failing, instead of leaving you to diagnose several simultaneous refreshes. Once individual queries behave as expected, test Refresh All and verify the resulting tables and connection statuses.
Common problems and checks
If the setting does not appear, first confirm that you opened the query’s Properties from the Queries & Connections pane rather than looking only at Power Query Editor’s query options. Then check whether the query is loaded to a worksheet, the Data Model, or connection-only, and whether the selected connection exposes the option. Excel does not offer every refresh property for every connection type.
If Excel still seems busy after enabling the option, that does not necessarily mean it failed. Background refresh allows the interface to be available; it does not promise that every part of a workbook remains unaffected. A large query can consume memory, processor time, and network capacity, and other workbook activity may feel slower while it runs.
If the displayed results appear old, check whether the refresh has completed and whether it succeeded. In Queries & Connections, inspect the query’s status or error details. Also verify the source file or database has the expected data, and check credentials, file paths, network access, and privacy or access settings if the query reports an error. A failed refresh can leave previously loaded results visible, so visible data alone is not proof of a successful update.
If two actions seem to overlap, avoid making decisions from the output until the refresh finishes. For a process where timing matters, disable background refresh for the relevant connection if Excel permits it, or have the user explicitly wait for the status to complete before proceeding.
Do not confuse query refresh with preview refresh
Power Query Editor has options that control data previews, including whether previews are downloaded in the background in supported versions. Those settings affect what happens while you inspect or edit a query in the editor. They are not the same as Enable background refresh in the connection’s properties, which affects a refresh of the workbook connection.
Changing a preview option will not necessarily change how a loaded worksheet table refreshes. Likewise, enabling background refresh for a workbook connection does not mean that every preview in the editor will update in the background. If the issue happens while editing query steps, look at the editor’s query options; if it happens when updating the workbook’s loaded data, inspect the connection properties.
Excel for Mac and Excel for the web
The steps above are for Excel for Microsoft 365 on Windows. Power Query capabilities, supported sources, and refresh controls differ across Excel for Mac and Excel for the web, and not every Windows option is exposed in the same way on those platforms. If you cannot find the background-refresh control on a Mac or in a browser, check the current controls available for that version and connection rather than assuming that the Windows dialog path applies.
For a workbook that must use a particular connection-level setting, configure and verify it in the Windows desktop app when that is the supported environment. A workbook may also depend on a connector or credential method that is unavailable on another platform, so test the actual source and refresh workflow on the devices where the workbook will be used.
Frequently Asked Questions
Does background refresh make Power Query refresh faster?
No. It lets Excel return control while the refresh continues. The query still has to retrieve and transform its data, so the total refresh time may be unchanged.
Why is Enable background refresh grayed out?
The option may not be supported for the selected connection or its load configuration. Check that you opened the correct query’s Properties, and note the query’s destination and source type. If it remains unavailable, Excel does not offer that control for that connection in the current setup.
Can I keep working while a query refreshes?
Usually, that is the purpose of enabling background refresh. You can work elsewhere in Excel, but the workbook may still use significant system resources. Do not rely on the query’s output as updated until the refresh has completed successfully.
Does Refresh All wait for every query to finish?
Not necessarily in the sense that Excel must keep you waiting at the interface. With background refresh enabled for connections, Excel may return control while refresh work is ongoing. Check the status of the queries whose results matter.
Will a refresh continue after I close Excel?
No. Background refresh is not an unattended service or a scheduled cloud refresh. Keep Excel open while the operation runs, and use an appropriate service or automation workflow if refreshes must run without a person keeping the workbook open.
Related
- Excel Merge Shortcut: Keys, Options, and Safer Methods
- Excel Merge Keyboard Shortcut and Safer Alternatives
- Excel Meal Plan Template: Build a Weekly Planner That Works
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Automatically Remove Duplicates in Excel: Methods and RisksYes. In Excel for Microsoft 365 on Windows, select your data and choose Data > Remove Duplicates to…
- Remove a Red Line in Word? Causes and FixesTo remove a red line in a Word document, first identify what it marks: for a red change…
- Can Excel Goal Seek Multiple Cells at Once?No. In Microsoft Excel for Microsoft 365 on Windows, Goal Seek can adjust only one changing cell to…
- Paste Text to Columns in Excel: A Practical Guide and FixesTo split text into separate Excel columns, put the values in one column, select those cells, then choose…
- Excel Data Validation Images: What Works and How to Do ItIn Excel, a standard data-validation dropdown cannot show pictures: its choices are text or numbers. In Microsoft 365,…
- Excel Shortcut Mouse Pad: What to Look ForAn Excel shortcut mouse pad is a desk mat or mouse pad printed with keyboard commands and tips…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.