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.

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
Sandy wrote in message
...
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.