Refresh an Excel Power Query Table After Updating Source Data
Question details
Refresh a combined Excel table after updating its source data and determine why new data is missing from the loaded result.

- 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.
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.
Refresh the Combined Query and Worksheet Table
Use this first when the source data has changed but the combined table has not been refreshed.
In Excel, select Data > Refresh All and wait for the refresh to finish.
If the result is still unchanged, right-click a cell in the combined worksheet table and select Refresh.
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.
If the preview is correct, select Home > Close & Load. Return to the worksheet and refresh the loaded table again if needed.

Check Power Query Source Settings and Filters
Use this when a refresh completes but the combined query still omits the updated rows.
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.

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.




