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
  4. Refresh button

    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
  4. 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.

    Change PivotTable Data Source dialogue box

  5. Select a new range and click Ok
  6. The PivotTable updates with the data from its new source.

Follow us on

Facebook  Twitter  You Tube