How to Clear a Pivot Table Cache

D

DoctorG

I have a workbook with years of company data along with a Pivot Table using
those data. I wanted to give this workbook as a "template" to a friend to use
it in his work.

I deleted most of the data so that he would enter his own but I wanted to
leave the Pivot structure as it is. The thing is I cannot get the Pivot to
clear its cache and "forget" all the row data it has had all this time. I can
do a Clear All on the Pivot which clears everything along with the structure.
Is there a way to clear all data no longer present in a workbook (maybe
there is something else besides a Pivot with this behavior).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top