How to Update a Pivot Table in Excel?

Click anywhere inside the pivot table

Go to the PivotTable Analyze or Options tab

Click Refresh

Right-click the pivot table and select Refresh

Use Refresh All on the Data tab to update all pivot tables and connections

Change the source data range if the data has been expanded

Go to PivotTable Analyze or Options and select Change Data Source

Select the new data range

Click OK

Refresh the pivot table again

If the pivot table does not show new fields, update the source table or range

If using a table as the source, add the new data to the table and refresh

If the layout needs changes, drag fields in the PivotTable Fields pane

Save the workbook after updating the pivot table

Suggested for You

Trending Today