Power Query Problems

Refresh an Excel Power Query Table After Updating Source Data

Algirdas JasaitisAlgirdas Jasaitis Nov 18, 2026 869 views

Question details

Refresh a combined Excel table after updating its source data and determine why new data is missing from the loaded result.

Refresh an Excel Power Query Table After Updating Source Data
Product
Microsoft Excel Power Query
Device & OS
not provided
Scenario
The user has updated 2023 source data and wants the combined worksheet table to reflect those changes.
Observed behavior
Updated 2023 data appears in Power Query but does not appear in the combined Excel table.
Before you start

Confirm that the updated source file is saved and accessible, and identify the query that loads the combined table. If the source is a worksheet range, check whether the new rows are inside the source Excel Table.

Solution 1Recommended

Refresh the Combined Query and Worksheet Table

Use this first when the source data has changed but the combined table has not been refreshed.

1
Refresh all connections

In Excel, select Data > Refresh All and wait for the refresh to finish.

2
Refresh the loaded table

If the result is still unchanged, right-click a cell in the combined worksheet table and select Refresh.

3
Check the query preview

Select Data > Queries & Connections, right-click the combined query, and select Edit. In Power Query Editor, select Home > Refresh Preview and check whether the updated rows appear.

4
Apply the query

If the preview is correct, select Home > Close & Load. Return to the worksheet and refresh the loaded table again if needed.

Refresh the Combined Query and Worksheet Table
Preview and worksheet results: Refreshing the preview checks the data in Power Query Editor; it does not by itself guarantee that the worksheet table has refreshed.
Free Microsoft Office alternative

Work With Excel Tables in WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Microsoft Excel formats, making it easy to move everyday workbook tasks to WPS. Use Excel to troubleshoot and refresh its Power Query connections.

Open and edit Excel workbook formats, including XLSXReview and organize worksheet tables in WPS SpreadsheetUse a familiar interface for everyday spreadsheet tasksMove between compatible Office documents with a lightweight, free suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does the updated data appear in Power Query but not in my worksheet?

The query preview and the loaded worksheet table may not have refreshed together. In Power Query Editor, select Home > Close & Load, then right-click the worksheet table and select Refresh.

How can I check which file or sheet the query uses?

Select Data > Queries & Connections, right-click the query, and select Edit. In Query Settings, inspect the Source and Navigation entries under Applied Steps.

Why are newly added rows missing after a refresh?

The rows may be outside the source range or excluded by a filter. Select the source Excel Table and use Table Design > Resize Table to include the rows, then check the query's Applied Steps for filters.

Can WPS Office repair an Excel Power Query refresh?

WPS Office can open and edit compatible Excel workbooks, but it does not repair Microsoft Excel Power Query connections. Use Excel's Queries & Connections and Power Query Editor to inspect and refresh the query.