Thread: 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