Why do old, unused values still show in my Pivot Page fields?
 

When I originally created a PivotTable based on an Access database, for one
of the page fields I used a certain set of range values (i.e. 560-600,
600-650, etc.). We've decided the range values need to be different & I
recreated & replaced the data in the Access DB with the new range values.
But, my PivotTable still shows the old, unused values along with the new,
correct ones. I don't want to recreate the PivotTable because I've created a
large number of calculated fields. How do I get rid of the unwanted range
values in that Page field?

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

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



NateBrei wrote:
When I originally created a PivotTable based on an Access database, for one
of the page fields I used a certain set of range values (i.e. 560-600,
600-650, etc.). We've decided the range values need to be different & I
recreated & replaced the data in the Access DB with the new range values.
But, my PivotTable still shows the old, unused values along with the new,
correct ones. I don't want to recreate the PivotTable because I've created a
large number of calculated fields. How do I get rid of the unwanted range
values in that Page field?


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

Here are instructions

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


Regards,

Peo Sjoblom

"NateBrei" wrote:

When I originally created a PivotTable based on an Access database, for one
of the page fields I used a certain set of range values (i.e. 560-600,
600-650, etc.). We've decided the range values need to be different & I
recreated & replaced the data in the Access DB with the new range values.
But, my PivotTable still shows the old, unused values along with the new,
correct ones. I don't want to recreate the PivotTable because I've created a
large number of calculated fields. How do I get rid of the unwanted range
values in that Page field?

How do you keep the old ones and prevent the new ones from appearing?

Tom

"Peo Sjoblom" wrote:

Here are instructions

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


Regards,

Peo Sjoblom

"NateBrei" wrote:

When I originally created a PivotTable based on an Access database, for one
of the page fields I used a certain set of range values (i.e. 560-600,
600-650, etc.). We've decided the range values need to be different & I
recreated & replaced the data in the Access DB with the new range values.
But, my PivotTable still shows the old, unused values along with the new,
correct ones. I don't want to recreate the PivotTable because I've created a
large number of calculated fields. How do I get rid of the unwanted range
values in that Page field?