Refresh by right click on pivot table

Pivot table before update

Refresh by right click on pivot table to view updated data in the pivot table

Pivot table before update
Updated pivot table after source data update