Pivot Table Issues

Fix Old Data in an Excel PivotTable After Changing the Source Range

Steven ParkerSteven Parker Nov 18, 2026 869 views

Question details

The user needs an Excel PivotTable or PivotChart to reflect changes and new rows in its source data.

Fix Old Data in an Excel PivotTable After Changing the Source Range
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user has changed or added data in the range used by a PivotTable or PivotChart.
Observed behavior
The PivotTable or PivotChart continues to show old data because its source may be a fixed range or its cached data has not been refreshed.
Before you start

Locate the PivotTable's source data and check that each column has a header. Make sure the new rows you want to include are adjacent to the existing source data.

Solution 1Recommended

Use an Excel Table as the PivotTable source

Use this method when new source rows should be included without manually expanding a fixed range each time.

1
Create a source Table

Select the source data, including its headers and any new rows, then choose Insert > Table. Confirm the range and select My table has headers if applicable.

2
Find the Table name

Click inside the new Table and open the Table Design tab. Note the name shown in the Table Name box.

3
Change the PivotTable source

Click inside the PivotTable, then choose PivotTable Analyze > Change Data Source. Enter or select the Table name and confirm.

4
Refresh the results

Right-click the PivotTable and select Refresh, or choose Data > Refresh All to update the workbook's PivotTables and PivotCharts.

Use an Excel Table as the PivotTable source
Refresh after adding rows: Rows added to the Excel Table become part of its source range, but you still need to refresh the PivotTable to show the updated results.
Free Microsoft Office alternative

Work with spreadsheet data in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheet to review and analyze data while moving between office suites.

Analyze spreadsheet data with PivotTable toolsOpen and work with Microsoft Excel XLSX and XLS filesUse a familiar interface for an easier transition from ExcelKeep a lightweight office suite available for everyday work
microsoft office alternative - wps office

Frequently Asked Questions

Why does my PivotTable still show old data after I edit the source?

The PivotTable may be using cached data. Right-click it and select Refresh. If new rows are missing, also check PivotTable Analyze > Change Data Source to see whether the source includes them.

Will an Excel Table automatically update my PivotTable?

An Excel Table expands to include rows added to it, but the PivotTable still needs to be refreshed. Right-click the PivotTable and select Refresh after adding or changing data.

How do I find the name of my source Table?

Click any cell in the Table, open the Table Design tab, and look for the Table Name box. Use that name in PivotTable Analyze > Change Data Source.

How can I update a PivotChart that shows old data?

Check the source of its associated PivotTable under PivotTable Analyze > Change Data Source, then select Data > Refresh All to refresh the workbook's PivotTables and PivotCharts.