why pivot table does not refresh?
1. Changing data in source data set. When we change any text or number in existing source data range, then this change is not automatically captured in the Pivot Table, so we need to refresh the Pivot table manually. ... Go to Pivot Table tools > On Options /Analyze Tab > In Data group, click on Refresh.