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


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


Michael Rekas wrote:
The column field list of my PivotTable (when one clicks on the
drop-down arrow) is populated with a list of items which no longer
exist in the data table from the data is drawn.

Is it possible to reset these values so that only valid data can be
selected.


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