Refresh pivot table

If you have changed the source data for your table, you need to update the pivot table to reflect these changes.

Update a pivot table with new source data

1. Right-click any cell within the pivot table.
2. In the context menu, select Refresh pivot table.

You can also use the Refresh pivot table tool on the Home tab, in the Pivot table group.