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.