How To Refresh A Pivot Table?

Click anywhere inside the pivot table

Go to the PivotTable Analyze or Options tab

Select Refresh

Right-click the pivot table and choose Refresh

Use Refresh All to update all pivot tables in the workbook

Press Alt + F5 to refresh the selected pivot table

Press Ctrl + Alt + F5 to refresh all data connections and pivot tables

If needed, change the source data range first, then refresh the pivot table

Suggested for You

Trending Today