Pivottable Items refresh

[Guest]

After a refresh of a Pivot Table, items from the previous data are still available in my field selection window, even though they are not valid in the current refreshed version

How do I clear out the unused items in the pivotfield's selection window?

 

[Debra Dalgleish]

As answered in .programming:

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

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

 

[Guest]

Thanks... great site!