Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do not show rows with no values in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
add a column to a pivot table that would show the difference between 2 other Columns | Excel Worksheet Functions | |||
Sum minimum values in a pivot table | Excel Worksheet Functions |