access vba courses - Excel Pivot Table Cache

Hello,

Could you please tell me how I can clear the cache of a pivot table without creating a new table.

Example in my first set of data I have items 'A', 'B' and 'C' and therefore these appear in the pivot, however when I generate a new set of data I now have the items 'A', 'B' and 'D'. In the pivot table memory I still see A B C and now D (eventhough C is no longer in my data). How can I clean the pivot table to remove C?

Thanks,

Lawrence