How To Update Pivot Table?

Select the pivot table

Go to the PivotTable Analyze or Options tab

Click Refresh

To update the data source, click Change Data Source

Select the new or expanded data range

Click OK

Refresh the pivot table again

If needed, right-click the pivot table and choose Refresh

For all pivot tables in the workbook, use Refresh All from the Data tab