Power Query Problems

Fix Power Query Creating a New Table Instead of Updating the Existing Table

Nimra MalikNimra Malik Nov 20, 2026 868 views

Question details

Determine why a Power Query load creates a new table instead of updating the existing output used by PivotTables.

Fix Power Query Creating a New Table Instead of Updating the Existing Table
Product
Microsoft Excel for Microsoft 365
Device & OS
not provided
Scenario
The user edits a Power Query and selects Close & Load, expecting the existing query output table and linked PivotTables to remain usable.
Observed behavior
Excel creates a new worksheet and table, sometimes with a suffix such as _2, rather than updating the original output table.
Before you start

Identify the original query output table and the PivotTables and slicers that depend on it. In Excel, open Data > Queries & Connections to locate the query and check its current load destination.

Solution 1Recommended

Test and rebuild the query in a new workbook

Use this approach to determine whether the behavior is specific to the original workbook and query.

1
Inspect the query

In the original workbook, select Data > Queries & Connections, right-click the affected query, and choose Edit.

2
Copy the query code

In Power Query Editor, open Home > Advanced Editor and copy the query code. Note any other queries or parameters it references.

3
Test in a new workbook

Create a new Excel workbook, select Data > Get Data > From Other Sources > Blank Query, and paste the code into Advanced Editor. Recreate any required parameters or dependent queries and provide source credentials if prompted.

4
Check the load behavior

Select Home > Close & Load, then edit the query again and select Close & Load. Check whether the same output table is updated rather than a new one being created.

5
Rebuild if needed

If the new workbook behaves normally, recreate the affected query in the original workbook or use the tested query in a new workbook. Recreate affected PivotTables and slicers if their existing connections cannot be restored.

Test and rebuild the query in a new workbook
Share a sanitized example: If the issue persists, remove sensitive data from a sample workbook or query and provide it to the support team investigating the behavior.
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Excel workbooks. Its format compatibility can make moving everyday spreadsheet work easier, but it does not repair Microsoft Excel Power Query loading behavior.

Open and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for everyday workbook tasksWork with tables and PivotTables in compatible spreadsheetsMove common Office documents between WPS Office and Microsoft Office
microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Query create a table with a _2 suffix?

A suffix can appear when Excel needs a unique table name for a new output. Check Data > Queries & Connections and inspect the query's load settings; the suffix alone does not identify the underlying cause.

How can I tell if the problem is specific to my workbook?

Copy the query code from Power Query Editor > Home > Advanced Editor into a blank query in a new workbook. Load it, edit it, and load it again to see whether the original output updates.

Can I point an existing PivotTable to the new query table?

Select the PivotTable and choose PivotTable Analyze > Change Data Source, then select the new table. Refresh the PivotTable and verify its fields and slicer connections.

Should I delete the original query output sheet?

Wait until you have confirmed that the affected PivotTables and slicers work with the new table. Then, if the old sheet is no longer needed, right-click its worksheet tab and select Delete.