1. From the Ribbon choose: PivotTable Tools > Options > Refresh
2.Press ALT+F5
3.Right click in your Pivot Table and choose Refresh (see this option below)
STEP 1: Change the information in your data set.
STEP 2: Click in the Pivot table.
STEP 3: Right click and select Refresh.
The Pivot Table values are now updated!
John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.