Yes. In Excel for Microsoft 365 on Windows, you can set a Power Query connection to refresh when the workbook opens or at a recurring interval while the workbook is open. Open Data > Queries & Connections, right-click the query, choose Properties, and use the options on the Usage tab; for a one-time update, choose Data > Refresh All.
What automatic refresh means in Excel
Power Query imports or connects to data, applies transformation steps, and loads the result to a worksheet table or the Data Model. Refresh runs those steps again against the source. It does not continuously watch a file or update every time the source changes. Instead, Excel refreshes in response to a command or a setting, such as refresh on open or refresh every specified number of minutes.
This distinction matters when a report appears out of date. A query can be configured correctly but still show old results because the workbook has not been refreshed, the source has not changed yet, or Excel cannot reach the source. A refresh can also take time, especially if the source is large or requires a network connection.
Automatic settings belong to a workbook connection or query, not to every Power Query workbook everywhere. If a workbook has several queries, check the settings for each relevant one. A query that depends on another query may also need its upstream data refreshed before its output is current.
Turn on refresh when the workbook opens
For a workbook that should update whenever someone opens it, configure the query’s connection properties in desktop Excel for Windows:
- Open the workbook and select Data > Queries & Connections.
- In the pane, right-click the query and choose Properties. If the query is loaded as a connection, you can also open the properties of its connection.
- On the Usage tab, select Refresh data when opening the file.
- Choose OK, save the workbook, and test the setting by closing and reopening it.
Depending on the source and connection, Excel may display a prompt, ask for credentials, or need permission to access a file or service. The setting tells Excel to attempt a refresh; it does not guarantee success if the source is unavailable or sign-in has expired. For a workbook used by other people, make sure they have access to the source and understand any prompts they may see.
Refresh on open is useful for a weekly sales report or a workbook that reads a shared folder, because users can start with recent data without remembering a manual refresh. It can be less suitable when opening the workbook must be immediate, when the source is slow, or when users need a stable snapshot rather than the latest available values.
Refresh at regular intervals while Excel is open
If you want the query to update repeatedly during a work session, open the same Properties dialog and, where available for that connection, select Refresh every and enter a number of minutes. The interval is a polling schedule, not a guarantee that data changes will appear at that exact moment. Excel must be running with the workbook open, and a refresh can take longer than the interval if a previous refresh is still underway.
This option can be useful for a team monitoring a frequently updated data source during the day. It is usually unnecessary for a source that changes only once overnight. Frequent refreshes can add load to a database or web service, consume network resources, and interrupt work if queries are large. Choose a reasonable interval based on how often the source changes and how quickly users need to see updates.
Some connections also offer Enable background refresh. When supported and selected, Excel can let you continue working while the refresh runs. The displayed output may remain unchanged until the operation finishes, so do not treat a still-visible table as proof that the refresh has completed. Background refresh availability and behavior depend on the connection and query setup.
Use Refresh All for an on-demand update
To refresh on demand in Excel for Windows, select Data > Refresh All. You can also open Data > Queries & Connections, right-click a particular query, and choose Refresh when only that query needs updating. Refresh All is useful before sending a report or checking results after a source file has been replaced.
Refresh All can update multiple connections, not just one Power Query result. A workbook may contain queries, linked data, and PivotTables, so allow the operation to finish before reviewing the report. If a PivotTable uses the query output, confirm that the PivotTable reflects the newly loaded data; if necessary, refresh the PivotTable as well. The exact order and behavior can depend on how the workbook’s connections and reports are arranged.
For a clear handoff, save the workbook after a successful refresh if the refreshed output should be available to someone who opens it without refreshing. Saving preserves the current workbook state, but it does not make the source data live or guarantee that another user can refresh it.
Can Power Query refresh a closed workbook?
Excel desktop does not provide a built-in interval timer that keeps refreshing a workbook after the workbook has been closed. Refresh every operates while the workbook is open in Excel. Refresh data when opening the file runs when it is opened, not continuously in the background while nobody has it open.
If a process must run on a schedule without a person opening the workbook, that is a separate automation requirement. Depending on the source and the desired destination, options may include a scheduled data-platform refresh, a database or server-side job, or an approved cloud automation workflow. These approaches have their own licensing, connector, authentication, and file-format limits. Do not assume that a desktop refresh setting alone will run on a schedule in the cloud.
Opening Excel through a macro or a scheduled desktop task is sometimes proposed as a workaround, but it introduces reliability and security concerns: the computer must be available, sign-in and prompts must be handled, and unattended Office automation may be restricted in managed environments. For business-critical schedules, use an automation method supported by the organization’s Microsoft 365 and data-source setup.
Sources, credentials, and privacy affect refresh
Power Query can connect to many kinds of sources, including workbooks, text files, databases, and online services. Automatic refresh can fail if a file has moved, a network or VPN is unavailable, permissions changed, or an online account needs to sign in again. A query that worked on its creator’s computer may not work for a colleague whose file paths, credentials, or access rights differ.
When troubleshooting a connection, check the source location and sign-in method first. For a local or shared file, verify that the path is reachable from the computer doing the refresh. For an online service, confirm that the account still has access. Power Query’s privacy-level settings can also affect how data from multiple sources is combined; do not lower privacy protections casually just to make a refresh succeed.
It is also important to distinguish refreshing a query from refreshing its source. Power Query reads what the source makes available at refresh time. If a source system publishes data only every hour, asking Excel to refresh every minute will not produce newer source records. The query may simply retrieve the same data repeatedly.
Protect the query output and workbook design
A query loaded to a worksheet creates an output table managed by Power Query. Treat that table as generated data: typing corrections directly into its rows is not a reliable way to edit the underlying records, because a later refresh can replace the output. Make corrections in the source or add an intentional transformation step in Power Query. Keep manual notes or calculations in separate columns or sheets designed for that purpose.
Before enabling automatic refresh, consider what changes when the result grows or shrinks. A table may gain rows, formulas or charts may need to include them, and a report based on a fixed cell range may omit new records. Excel tables and structured references often handle expanding data more robustly than fixed ranges, but review dependent formulas, charts, and PivotTables after changing the query.
For a workbook that must show a known reporting period, keep a copy or snapshot of the relevant data before refreshing, or document the refresh date. Automatic refresh is convenient for current operational data, but it may be wrong for an audit trail or a report intended to preserve the figures originally reviewed.
Common refresh problems and practical checks
- The query still shows old data: Check that the refresh finished, then verify that the source itself contains newer records. Confirm that the correct query is being refreshed.
- Refresh fails when someone else opens the file: Check their source access, credentials, network connection, and privacy settings. A workbook does not transfer every user’s permissions to its data source.
- The workbook opens slowly: Refresh-on-open can delay access, especially with several large queries. Turn it off for connections that do not need current data at every opening, or consider a less frequent refresh plan.
- Values appear to change after refresh: Check query steps such as filters, type conversions, and sorting, as well as changes in the source. A refresh re-applies the steps to current source data; it is not simply a visual reload.
- A report or PivotTable is not current: Determine whether the report depends on the refreshed query output and whether it needs a separate refresh. Also check that the query is loaded to the location or model the report actually uses.
When a refresh error appears, open the query in Power Query Editor and inspect the step where the error occurs. This can help distinguish a broken source path from a changed column name, incompatible data type, or source-side problem. Avoid deleting steps or changing credentials blindly; first identify which dependency changed.
Excel for Mac and Excel for the web
The steps above describe Excel for Microsoft 365 on Windows. Power Query is also available in current Microsoft 365 versions of Excel for Mac, but connector support, editing features, and connection-property controls can differ by platform and release. If you do not see the same Usage-tab options, check the query or connection properties available in your Mac build and update Excel before assuming the workbook has no refresh capability.
Excel for the web supports refreshing some Power Query data and has a growing set of query capabilities, but not every connector, authentication method, or editing operation is available in every environment. A workbook created on Windows may therefore refresh differently in a browser. For a workbook that depends on a particular source, test the exact refresh workflow in the platform where it will be used.
Frequently Asked Questions
Does Power Query refresh automatically in Excel?
Only when you configure a refresh option or issue a refresh command. You can set refresh on workbook open or, for supported connections, an interval while the workbook is open. Otherwise, use Data > Refresh All or refresh a specific query.
How do I make Power Query refresh every minute?
Open Data > Queries & Connections, right-click the query, choose Properties, and look for Refresh every on the Usage tab. Enter the interval if the option is available. Excel must remain open with the workbook open, and one-minute refreshes may be excessive for large queries or busy sources.
Will Excel refresh Power Query when the file is closed?
No, not through the normal desktop refresh interval setting. Refresh-on-open runs after someone opens the workbook. A closed-workbook schedule requires a separate supported automation or data-refresh service.
Does Refresh All update PivotTables too?
It refreshes workbook connections and may update related reports, but behavior depends on how the PivotTable is connected and configured. Check the PivotTable after the query completes and refresh it separately if its displayed results remain stale.
Why does automatic refresh ask me to sign in?
The source may require authentication, or saved credentials may have expired or be unavailable to the current user. Sign in with an account that has source access, and confirm that the connection is configured for the intended authentication method.
Related
- Excel Number Format for Leading Zeros: How It Works
- Excel Number Format for Leading Zeros: A Practical Guide
- Excel Number Format: How to Show Zero as a Dash in Cells
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Delete a Filter View in Google SheetsTo delete a filter view in Google Sheets, open the spreadsheet in a web browser, go to Data…
- Clean Excel Rows: Remove Blanks, Duplicates, and ErrorsTo clean Excel rows, first make a copy of the workbook, then standardize inconsistent values, identify genuinely blank…
- Smartsheet DataTable Explained: Uses, Setup, and LimitsA Smartsheet DataTable is a centrally managed data store that can feed selected records into Smartsheet sheets, helping…
- Keyboard Shortcut for X Mark in Excel and Other OptionsFor a multiplication-style x (×), hold Alt and type 0215 on the numeric keypad, then release Alt; Excel…
- Excel Data Entry Form: Add an Image Box Step by StepTo add an image box to an Excel data entry form, place a picture in a worksheet cell…
- Can You Insert a Digital Signature in Word?Yes. In Word for Microsoft 365 on Windows, you can add a signature line and sign it with…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.