Fix Old Data in an Excel PivotTable After Changing the Source Range
Question details
The user needs an Excel PivotTable or PivotChart to reflect changes and new rows in its source data.

- 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.
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.
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.
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.
Click inside the new Table and open the Table Design tab. Note the name shown in the Table Name box.
Click inside the PivotTable, then choose PivotTable Analyze > Change Data Source. Enter or select the Table name and confirm.
Right-click the PivotTable and select Refresh, or choose Data > Refresh All to update the workbook's PivotTables and PivotCharts.

Update a fixed source range and refresh the PivotTable
Use this method if you prefer to keep a cell range instead of converting the source to a Table.
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.

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.




