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
