need to clear data references in pivot table report
 

I have a sheet that records registration data. It is supported by different
Pivot Table reports. The data in the main sheet changes twice a year and I
need to find a way to clear the references that the reports use (as in 'show
all', 'blank', etc.). I can clear the data from the main sheet, but the
reports hold the data references. It is not affecting the reports
functioning, it is just creating a HUGE reference list.

There are instructions here for clearing old items from a PivotTable
dropdown list:

http://www.contextures.com/xlPivot04.html


Mikeeusa wrote:
I have a sheet that records registration data. It is supported by different
Pivot Table reports. The data in the main sheet changes twice a year and I
need to find a way to clear the references that the reports use (as in 'show
all', 'blank', etc.). I can clear the data from the main sheet, but the
reports hold the data references. It is not affecting the reports
functioning, it is just creating a HUGE reference list.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thank You!! It worked except for one tough field which I can live with. It is
astonishing to me how little MS helps with Pivot Tables in general. Thanks
again.

"Debra Dalgleish" wrote:

There are instructions here for clearing old items from a PivotTable
dropdown list:

http://www.contextures.com/xlPivot04.html


Mikeeusa wrote:
I have a sheet that records registration data. It is supported by different
Pivot Table reports. The data in the main sheet changes twice a year and I
need to find a way to clear the references that the reports use (as in 'show
all', 'blank', etc.). I can clear the data from the main sheet, but the
reports hold the data references. It is not affecting the reports
functioning, it is just creating a HUGE reference list.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

You're welcome! Thanks for letting me know that it helped.

Mikeeusa wrote:
Thank You!! It worked except for one tough field which I can live with. It is
astonishing to me how little MS helps with Pivot Tables in general. Thanks
again.

"Debra Dalgleish" wrote:


There are instructions here for clearing old items from a PivotTable
dropdown list:

http://www.contextures.com/xlPivot04.html


Mikeeusa wrote:

I have a sheet that records registration data. It is supported by different
Pivot Table reports. The data in the main sheet changes twice a year and I
need to find a way to clear the references that the reports use (as in 'show
all', 'blank', etc.). I can clear the data from the main sheet, but the
reports hold the data references. It is not affecting the reports
functioning, it is just creating a HUGE reference list.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html