Take a look at
http://www.contextures.com/xlPivot04.html

or better still download the add-in Debra has created and use the option
within it
http://www.contextures.com/xlPivotAddIn.html

--
Regards
Roger Govier
"Mike W" wrote in message
...
I have pivot tables in workbooks that I copy from one day to the next and,
over time, these pivot tables have retained products and serial numbers
that are no longer used. Without re-creating the pivot table, is there a
way of flushing out the old data?

thanks,

Mike