Thanks for giving a clue (Pivot Table) just place the cursor inside the pivot table data and do right click and click REFRESH. whenever any change happen in source data then PIVOT TABLE requires REFRESH to get the changes reflected.

Sent from mobile device so regret for the delayed reply.