If Excel Power Query is not updating, select Data > Refresh All in Excel for Microsoft 365 on Windows, then check whether the query’s source, credentials, and load destination are correct. If the result still looks old, refresh the query itself and use the checks below to identify whether the problem is in the source, the query, or the table or report that displays its results.
First, identify what is not updating
Power Query gets data from a source, applies steps such as filtering or changing column types, and loads the result to a worksheet table, the Data Model, or a connection. A refresh asks Excel to run that process again. The visible problem can occur at any point, so clarify what you expected to change before altering the query.
- The source file changed, but the query result did not: check the file path, source selection, and refresh status.
- The query result changed, but a PivotTable did not: refresh the PivotTable or its underlying model as well.
- The query is absent from the worksheet: check whether it is set to load to a worksheet or only to a connection or the Data Model.
- The query returns an error: open the query and inspect the failing step and its error details.
Also confirm that you opened the workbook containing the query and that you are looking at its intended output. A query can refresh successfully without writing a table to the sheet you expected.
Refresh a query and check its status
In Excel for Microsoft 365 on Windows, use Data > Refresh All to refresh the workbook’s connections and queries. To refresh just one query, open Data > Queries & Connections, right-click the query in the pane, and choose Refresh. Excel may take time to retrieve and transform a large source; watch the status bar or query pane rather than assuming nothing happened immediately.
If the workbook contains many connections, Refresh All can make it harder to see which one failed. Refresh the affected query on its own, then read any error message. For a deeper check, right-click the query in Queries & Connections and select Edit. In the Power Query Editor, choose Home > Refresh Preview to request a current preview. A preview refresh is useful for diagnosis, but it is not the same as loading the query’s results back into the worksheet. Select Home > Close & Load when you want to apply the editor changes and load the output.
On Mac, Power Query availability and the names or locations of commands can vary by Excel version and source connector. Look for refresh commands on the Data tab and in the queries or connections interface available in that release. Excel for the web also supports only a subset of refresh scenarios; if a source or authentication method is unavailable there, open the workbook in desktop Excel.
Verify that the query points to the current source
A refresh repeats the query’s existing instructions; it does not automatically search for a newer file or change the source address. This is a common reason a refresh appears to do nothing. For example, a query may still read MonthlySales.xlsx from an old folder even after a new copy has been saved elsewhere.
Open the query in Power Query Editor and inspect the Applied Steps list. Select the first step, often named Source, and confirm its file, folder, database, website, or other address. Check that the expected worksheet, table, folder, or database object is selected too. If a file was renamed or moved, update the source through the relevant source settings or edit the source step, then verify later steps still refer to columns and objects that exist.
Folder queries deserve particular attention: they may combine every matching file in a folder, not just the newest one. Check the folder path and any filename filters. If the latest file has a different column layout, the combine-files steps can fail or exclude it. For a workbook source, make sure the data was saved to the file the query reads; unsaved changes in another open workbook are not necessarily available to the query.
Check credentials and privacy settings
A source can be reachable but still refuse a refresh because Excel needs valid permissions. Common examples include a database password that changed, an expired sign-in, a moved SharePoint file, or a network location that is not available. Power Query may show an authentication or access error rather than silently updating the table.
In Excel for Windows, open Data > Get Data > Data Source Settings to review permissions for sources used by the workbook or on the current computer. Select the relevant source and use the available edit, clear, or permission options to sign in again or correct the stored access. The exact sign-in flow depends on the connector and organization. Do not enter credentials into an untrusted prompt, and do not weaken an organization’s security settings to bypass a refresh error.
Privacy levels can also affect queries that combine sources, such as a public web table joined to a private workbook. Excel uses privacy settings to help control how data from different sources is combined. If a privacy warning appears, review the source levels and your organization’s guidance; setting every source to Public is not a general fix. Refreshing on a different computer or in Excel for the web may require authentication again.
Inspect errors and broken transformation steps
A query can connect successfully and still fail while transforming the returned data. Changes to a source’s column names, data types, or structure can invalidate later steps. For instance, a step that removes a column named Region may report an error if the source renamed it to Sales region. A date conversion can also fail if new rows contain text that is not a valid date.
Choose Edit for the query and select the first step that shows an error. Read the message and inspect the preview at that step. Earlier steps may work while a later filter, merge, expansion, or type conversion fails. Fix the step that no longer matches the source, then check the remaining steps in order. Do not simply delete error-producing steps without considering whether doing so would discard important records.
If the query uses a merge, verify that both inputs still contain the join columns and that their data types match. If it expands a nested table, confirm the expected fields are still present. Source files with extra rows usually refresh without trouble, but changes to headings or layout can break assumptions built into the transformation.
Confirm where the results are loaded
Power Query queries do not all create visible worksheet tables. A query can be configured as connection-only, loaded to the Data Model, or loaded to a worksheet. In Queries & Connections, right-click the query and choose Load To when that option is available to review or change its destination. The options shown depend on the query and workbook.
If the query is connection-only, a successful refresh may leave the worksheet unchanged because there is no worksheet table to replace. If it loads to the Data Model, its rows may be used by a PivotTable or other model-based report rather than displayed directly. Check the query’s load destination before rebuilding it or importing a duplicate.
When a query does load to a table, look for the table’s refresh indicator or status and verify that you are viewing the correct output sheet. If the output is filtered or sorted, new rows may be present but not visible in the current view. Also check whether another query or formula-driven report uses this table; refreshing the source query does not necessarily update every separate object in the workbook.
Refresh PivotTables and other dependent reports
A refreshed query and a refreshed report are related but distinct. If a PivotTable uses the query output, try right-clicking the PivotTable and choosing Refresh, or use Data > Refresh All to refresh workbook connections and queries. If the PivotTable is based on the Data Model, confirm that the model’s source query completed successfully before diagnosing the report layout.
For a regular Excel table loaded by Power Query, formulas that refer to the table generally recalculate as Excel updates the workbook, subject to the workbook’s calculation settings and formula dependencies. If formula results remain old, check Formulas > Calculation Options and make sure calculation is not set to Manual. Calculation mode affects formulas; it does not retrieve new source data. Conversely, recalculating formulas cannot replace a Power Query refresh.
This distinction resolves a frequent misconception: pressing F9 recalculates formulas, but it does not refresh a Power Query connection. On Windows, Ctrl+Alt+F5 refreshes all data connections, while Ctrl+F5 refreshes the active data connection when applicable. Shortcut behavior can vary with keyboard and Excel configuration; the Data tab commands are a clear alternative. Mac shortcuts differ, so use the Data tab if a shortcut does not behave as expected.
Set refresh behavior for future workbooks
If the query works when refreshed manually but not when you reopen the file, configure its refresh properties. In the Queries & Connections pane, right-click the query and choose Properties. Depending on the connection, the properties window can offer settings such as refreshing data when the file opens or refreshing at a specified interval. Choose settings that suit the source and workbook size; frequent refreshes can slow work or send repeated requests to a shared system.
Background refresh can allow you to continue working while a connection runs, but it can also make it less obvious whether a refresh has finished before you inspect dependent results. If results appear inconsistent, wait for the refresh to complete and check its status. Some query types or settings may not offer every refresh option, and organizational policies can affect available connections.
Automatic refresh is not a guarantee that a file will update in every situation. The workbook must be opened or otherwise refreshed in an environment that supports its connector, the source must be available, and credentials must remain valid. A scheduled refresh service is a separate setup from a checkbox in desktop Excel and depends on the source and service being used.
Frequently Asked Questions
Why does Refresh All finish but my data still look the same?
Refresh All reruns the queries, but the source may genuinely contain no new records, the query may point to an older file, or a filter may exclude the changed rows. Check the Source step and filters, then inspect the refreshed query result rather than relying only on the button finishing.
Does pressing F9 refresh Power Query?
No. F9 recalculates formulas. Use Data > Refresh All or refresh the individual query from Queries & Connections to retrieve source data.
Why is Power Query not showing my latest rows?
Confirm that the rows were saved in the exact source file or database the query uses. Then check source filters, folder filename rules, and any steps that remove rows. A query only returns records allowed by its source and transformation steps.
Why does my PivotTable stay unchanged after a query refresh?
The PivotTable may need its own refresh, or it may use a different table or Data Model connection than the query you refreshed. Use Data > Refresh All, inspect the PivotTable’s source, and confirm the relevant query finished without error.
Can Power Query refresh automatically when I open a workbook?
Often, yes: right-click the query in Queries & Connections, choose Properties, and look for the option to refresh when the file opens. Availability depends on the connection, and automatic refresh still requires access to the source and valid credentials.
Will Power Query update in Excel for the web?
Some refresh scenarios are supported, but support depends on the source connector and authentication method. If the refresh option is unavailable or fails in the browser, open the workbook in desktop Excel and check the connector’s requirements.
A reliable troubleshooting order
To avoid changing several things at once, use this order: refresh the individual query, read its status or error, confirm the source path and data, inspect the failing transformation step, verify credentials and privacy prompts, and check the load destination. Finally, refresh dependent PivotTables or reports. This sequence separates a source problem from a transformation problem and from a display or reporting problem, making it easier to fix the cause without rebuilding a query that is already working.
Related
- Stampin’ Up Inventory Spreadsheet: What to Track
- Spreadsheet Free Budget Planner: A Simple Excel Setup
- Spreadsheet Budget: Build a Monthly Plan in Excel
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- VLOOKUP a ZIP Code Not Working? Fix Common Match ErrorsIf VLOOKUP cannot find a ZIP code, first check whether the lookup value and the ZIP codes in…
- Excel Error Messages: What They Mean and How to Fix ThemExcel error messages are codes such as #DIV/0!, #VALUE!, and #REF! that show a formula could not return…
- Excel and CSV Icons: What They Mean & How to Fix ThemThe icons you see next to Excel and CSV files are file-type associations—they tell Windows which program should…
- Excel Not Responding When Saving? How to Fix ItIf Excel says Not Responding while saving, give it a few minutes before closing it: a large workbook,…
- Excel Keeps Not Responding? Causes and Fixes to TryIf Excel keeps not responding, first give it a minute if it may be calculating or loading data;…
- Excel Showing Formula Instead of Result? Fix ItIf Excel is showing a formula instead of its result, first turn off Show Formulas from the Formulas…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.