Prev: Excel 2003 help doesn't work. I got both Excel 2003 and 2007 insta
Next: R1C1
From: DoctorG on 16 Feb 2010 09:54
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).
From: Luke M on 16 Feb 2010 10:04
Chekc out Debra's article on the various ways to clear out the PivotTable
memory.

http://www.contextures.com/xlPivot04.html
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"DoctorG" wrote:

> 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).
 | 
Pages: 1
Prev: Excel 2003 help doesn't work. I got both Excel 2003 and 2007 insta
Next: R1C1