There are instructions here for clearing old items from a pivot table:
http://www.contextures.com/xlPivot04.html
Kevin wrote:
When I select a drop-down to a filter row (or column) to select a value I
often see or can select values that are no longer in the datasource. Is there
a way to remove these simply.
only way i can figure out is to rebuild pivot report or move the value to
"page" and "hide items" but this is not very good or wise
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html