Refresh option by clicking on Data menu

Pivot table before update

Refresh option by clicking on Data menu

Updated pivot table after source data update
Refresh Pivot Table