Pivot Table Row Field

[Jen]

I created a pivot table in Excel 2000. There is only one
Row Field referring to a list of SalesRepNames. As Reps
terminate, their names in the source data are replaced by
new names.

When I refresh the pivot table, the old names are replaced
by the new names. However, the old names still appear in
the drop down list for the row field. How can I get rid
of the obsolete names?

 

[Debra Dalgleish]

There are instructions on my web site for clearing old items from a
PivotTable dropdown list:

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

 

[Jen]

Wow. Dragging the field off manually didn't do it, but
the code worked beautifully. Thank you so much! This
will help me tremendously!