Power Query Problems

Fix Excel Power Query and PivotTable Refresh Issues

Tauseeq MagsiTauseeq Magsi Nov 18, 2026 869 views

Question details

The user needs new monthly data to flow through Power Query source and appended queries into PivotTables.

Product
Microsoft Excel Power Query and PivotTables
Device & OS
not provided
Scenario
An Excel workbook uses monthly data-entry sheets, source queries, an appended query, and PivotTables.
Observed behavior
Refresh All does not correctly update every query or PivotTable after new data is entered.
Before you start

Identify the monthly sheets, their source tables, the appended query, and the PivotTables that use its output. Note which recently entered rows are missing so you can check them at each stage of the refresh.

Solution 1Recommended

Check the source tables and query connections

Use this first when recently entered rows are missing from a query or PivotTable.

1
Inspect the source tables

On each monthly data-entry sheet, click inside the source table and check that the new rows are included in its boundaries. If necessary, use Table Design > Resize Table to include them.

2
Check each source query

Open Data > Queries & Connections, right-click a source query, and select Edit. In the Power Query Editor, select the Source step under Applied Steps and verify that it points to the intended table or range.

3
Review protection

On a protected data-entry sheet, check Review > Protect Sheet or Unprotect Sheet. Make sure users can enter data in the intended cells and that new rows can be included in the source table.

Check the source tables and query connections
Protected sheets: If a sheet requires a password to change protection, ask the workbook owner for help.
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility for an easier transition. It does not fix Excel Power Query refresh issues.

Open and edit Microsoft Excel XLSX and XLS filesReview and organize monthly spreadsheet dataUse a familiar interface for everyday spreadsheet tasksGet a free, lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Why are new rows missing after Refresh All?

The rows may be outside the source table or range. Click the table on the data-entry sheet and use Table Design > Resize Table if the new rows are excluded.

How do I check which table a Power Query uses?

Open Data > Queries & Connections, right-click the query, and select Edit. In the Power Query Editor, select Source under Applied Steps and inspect the referenced table or range.

Why does my PivotTable still show old data after the query refreshes?

The PivotTable may need a separate refresh, may use a different source, or may have filters hiding the new data. Check PivotTable Analyze > Change Data Source, then right-click the PivotTable and select Refresh.

Can worksheet protection prevent new data from being included?

Protection can prevent users from editing intended cells or changing the table. Check the sheet's settings under Review > Protect Sheet or Unprotect Sheet, and ask the workbook owner for permission if a password is required.