Fix Power Query Creating a New Table Instead of Updating the Existing Table
Question details
Determine why a Power Query load creates a new table instead of updating the existing output used by PivotTables.

- 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.
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.
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.
In the original workbook, select Data > Queries & Connections, right-click the affected query, and choose Edit.
In Power Query Editor, open Home > Advanced Editor and copy the query code. Note any other queries or parameters it references.
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.
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.
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.

Reconnect PivotTables to the newly loaded table
Use the newly created table as a workaround when the original output table no longer updates.
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.

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.




