Hi all,

I have 5 pivot tables which feeds data from a single worksheet. The data from this sheet change every month. Meaning, old data out (deleted) and new one's inn.

The problem I have is the old data I used in the Row Label (such as Customer Name) are still showing in all the pivot tables even though the record is no longer there.

Has anyone had this before? If so, please kindly share your solution.

Thank you in advance.