Fix an Old Workbook Path in an Excel PivotTable Source
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.

- 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.
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.
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.
Click inside the PivotTable, then choose PivotTable Analyze > Change Data 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.
Click OK, then choose PivotTable Analyze > Refresh. Reopen Change Data Source to check whether the old filename has returned.

Inspect Defined Names, Workbook Links, and Connections
Check for references that may still point to the old file if the path reappears after changing the source.
Recreate the PivotTable from the Current Table
Create a fresh PivotTable if the old path persists in the existing PivotTable or its cached metadata.
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.

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.




