Pivot Table help

[mikeg22]

I have set up a pivottable that relies on data in another worksheet
When I put new data in to the data worksheet, the field's old value
stay in the filter dropdown list on the pivottable. I want to know ho
to clear these values out so that only values that exist in the dat
are available to filter on.

Help please :

 

[Debra Dalgleish]

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

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