Updating a PivotTable and PivotChart

You can quickly update a PivotTable report using the PivotTable toolbar, which appears whenever a PivotTable is active. This saves you from having to recreate a PivotTable every time you add new data to a list. When you do want to add new data, Excel makes it easy by allowing you to drag data fields to and from a PivotTable or PivotChart.

Update a PivotTable Report

Make any necessary change(s) in the worksheet where your list range resides.

If necessary, select a different worksheet, and then click any cell in the PivotTable Report.

Click the Refresh Data button on the PivotTable toolbar, or click the PivotTable drop-down arrow on the PivotTable toolbar, and then click Refresh Data.

Add or Remove a Field in a PivotTable or PivotChart Report

Position the pointer over the field that you want to add to or remove from the PivotTable.

Drag the field on the PivotTable to add the field or drag it off the PivotTable to remove the field.

Did You Know?

You can hide and display fields on the PivotTable toolbar . Click the Hide Fields button on the PivotTable toolbar. Click the button again to display the PivotTable fields.