Refreshing

Refreshing a PivotTable updates it from its source. It does not recalculate automatically when the data changes: you have to refresh it. If the source is a structured table, new rows are taken into account on refresh, whereas a fixed range forces you to change the source.

Example

Right-click the PivotTable then Refresh, or Data > Refresh All.

Related concepts

The whole glossary