Pivot Table Issues

Fix an Old Workbook Path in an Excel PivotTable Source

Natalie TaylorNatalie Taylor Nov 18, 2026 868 views

Question details

The user needs to update a PivotTable that displays an old workbook filename in its source reference after the workbook is renamed or saved as a template.

Fix an Old Workbook Path in an Excel PivotTable Source
Product
Microsoft Excel
Device & OS
not provided
Scenario
A PivotTable should use a table in the current workbook after the file is saved under a new name.
Observed behavior
The PivotTable source reference displays the old workbook filename instead of referring only to the current workbook table.
Before you start

Open the renamed workbook and locate the table that should supply the PivotTable. Click the table and check its name on the Table Design tab so you can verify the source selection.

Solution 1Recommended

Reselect the Current Workbook Table as the PivotTable Source

Use this method first when the PivotTable should read from a table in the renamed workbook.

1
Open the source selector

Click inside the PivotTable, then choose PivotTable Analyze > Change Data Source.

2
Select the current source

In the Table/Range box, use the range selector and select the source table on the worksheet in the current workbook rather than typing the table name manually. Confirm that the selection does not point to the old workbook.

3
Apply and refresh

Click OK, then choose PivotTable Analyze > Refresh. Reopen Change Data Source to check whether the old filename has returned.

Reselect the Current Workbook Table as the PivotTable Source
Check the source type: If Change Data Source is unavailable or shows a connection rather than a table or range, inspect the connection under Data > Queries & Connections.
Free Microsoft Office alternative

Work with PivotTables in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and work with their data in WPS Spreadsheets for an easier transition from Microsoft Office.

Create PivotTables to summarize spreadsheet data.Open and save compatible Microsoft Excel XLSX and XLS files.Use a familiar interface for everyday spreadsheet tasks.Get a free, lightweight office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my PivotTable show the old workbook filename?

The PivotTable source, a defined name, a connection, or cached metadata may still refer to the earlier file. Check PivotTable Analyze > Change Data Source first, then inspect names and connections if the path returns.

How do I check the name of the source table?

Click a cell in the source table and open the Table Design tab. The table name appears in the Table Name box.

Why can't I change the PivotTable data source?

The PivotTable may use a connection or a data model rather than a worksheet table or range. Open Data > Queries & Connections to inspect the source, or create a new PivotTable from the current table.

Should I break every link to the old workbook?

No. Open Data > Workbook Links or Data > Edit Links and inspect each link first. Other formulas or connections may still need the old workbook, so change or remove a link only when you know it is no longer required.