Pivot tables remember values that are not available anymore

[.·:m·a·r·l·a:·.]

Hello everyone

I would like to ask you is it is possible to reset the fields in a pivot
table to make disapear values that they are not anymore available on the
data form the selection-criteria when a fields is drill down

example
lets make a simple table like ::


uno dos tres
a q 1
s q 2
d q 3
f q 4
g q 5
a w 6
s w 7
d w 8
f w 9
g w 0


make a pivot table and drilldown "uno" (row fields), drillacross "dos"
(column fields) and "tres" as Data-Items

so in the selection criteria for "uno" ther is the next options ::
- (Show all)
- a
- s
- d
- f
- g

now lets change both rows with letter g for h, and table will be like::

uno dos tres
a q 1
s q 2
d q 3
f q 4
h q 5
a w 6
s w 7
d w 8
f w 9
h w 0


so, refresh the pivot table and in the selection criteria; h have appear,
well; but g is still there !!!!


I have try already to set the pivot table to do not save the data and
refresh on open, and it does not help

any idea how to force to all this values disapear ??

thanks in advance

 

[Guest]

Here are 2 resources (both at Debra Dalgleish's website)

http://www.contextures.com/xlPivotPlay01.html
That add-in has a feature that does exactly what you want. When done, just
de-select the add-in until needed again.

or
For instructions
http://www.contextures.com/xlPivot04.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP