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?