PIVOT TABLE

[Sandy]

In case of pivot table, if i change source data, and refresh table, the
filters continue to show deleted data information. Example, if i have list of
clients which i deleted, and table shows clients Fields, if see drop down
filter, it continue to shows client names deleted with the new ones.

 

[Max]

If I'm not mistaken, think Debra Dalgleish has
some nice coverage on this at her:
http://www.contextures.com/xlPivot04.html