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