Excel > Excel 2007 Advanced > PivotTable and PivotCharts

Updating a PivotTable

If changes are made to the source data that the PivotTable is based on, the PivotTable needs to be manually refreshed. It does not update automatically.

Refresh PivotTable data

1. Select a cell in the PivotTable
2. Click the Options tab under PivotTable Tools on the Ribbon
3. Click the Refresh button in the Data group



The PivotTable updates with the changes made to the source data

Change PivotTable data source

It is possible to change the source data that the PivotTable is based on.

1. Select a cell in the PivotTable
2. Click the Options tab under PivotTable Tools on the Ribbon
3. Click the Change Data Source button in the Data group

The Change PivotTable Data Source dialogue box appears

The current data source appears in the Table/Range field and a moving dotted line surrounds the range on the sheet.



4. Select a new range and click Ok

The PivotTable updates with the data from its new source.

Changing a PivotTables calculation Sorting and filtering a PivotTable

Guides