To refresh Power Query data on open or on a timer, right-click the query in the Queries and Connections pane, choose Properties, and use the Usage tab. Tick "Refresh data when opening the file" for refresh on open, or tick "Refresh every" and enter the number of minutes. A workbook that is closed cannot refresh itself, so both options work only while the file is open in Excel.
Where exactly are these settings?
- Go to Data, then Queries and Connections. A pane opens on the right.
- Right-click your query and choose Properties.
- Open the Usage tab. You will see the refresh options listed there.
- Make your choices and click OK.
| Option on the Usage tab | What it does |
|---|---|
| Enable background refresh | Lets Excel stay usable while the query runs |
| Refresh every N minutes | Reruns the query on a timer while the file is open |
| Refresh data when opening the file | Runs the query as the workbook opens |
| Refresh this connection on Refresh All | Includes the query when you press Refresh All |
Option names can vary slightly between Excel versions, so read the labels you see. These settings are saved with the workbook and apply to that connection only. If your report uses several queries, set each one.
Should I refresh on open, on a timer, or both?
- Refresh on open suits a monthly statement workbook: you drop in the new file, open the workbook, and the numbers update. It happens once.
- A timer suits data that changes while you watch, such as a shared sheet that someone else keeps updating. For files you download once a month, it only repeats work.
- Use both for a dashboard left open on a second screen.
Say the workbook reads a statements folder and takes eight seconds to refresh. A timer of 5 minutes means the workbook spends those eight seconds twelve times an hour for no benefit. For a monthly statement, refresh on open is the sensible setting.
Why won't my closed workbook refresh by itself?
Excel is a program you run. It does the refresh, and a file sitting in a folder is just data. If nobody opens it, nothing runs. This is true even when the file is stored in OneDrive. If you need data to refresh with nobody there, you need something that opens Excel for you, such as a scheduled task on a computer that stays on, or a cloud tool built for scheduled refresh. Those depend on your setup and licence, so check what your account offers before you plan around it.
What should I know about background refresh?
- With background refresh on, Excel keeps working while the query loads. With it off, Excel waits and shows a progress box. Turn it off if one query must finish before another begins.
- Queries that depend on other queries can behave in an unexpected order with background refresh on. If totals look stale after a refresh, turn it off and try again.
- A refresh timer can interrupt you if you are typing in a cell that the query writes to. Load results to a separate sheet.
How do I check it works?
- Add one new row to a small source table or drop one new file in the statement folder.
- Save and close the workbook, then reopen it.
- Confirm that the new row appears in the loaded table.
- If nothing changes, check that the query is loaded to a sheet or the data model, since a connection-only query does not show a result.
If a manual routine is simpler for you, Data, Refresh All still does the job in one click. For people who would rather skip the refresh steps entirely, SpendixAI imports statements you upload, flags possible duplicate imports and keeps an import history with the status of each upload.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


