There are instructions here for clearing old items from a pivot table:

http://www.contextures.com/xlPivot04.html



will the intern wrote:
How can I reset my pivot chart 'search field' ? After I updated some data
from within the master sheet I am still seeing the information I deleted out
of certain columns appearing in the pivot chart 'search field'. Is there a
way to update the search fields?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html