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

Lawrence

On the Pivot table toolbar there is a red exclamation mark, for refreshing data, click that whilst you are in the pivot table.

let me know if this works for you.

regards

dave