Hi,

Debra has some information that may help.
http://www.contextures.com/xlPivot04.html

Cheers
Andy

WWW.CS wrote:
The field-level (column) selection boxes used to select the data to be
included in a pivot table include old and new values. How do I refresh these
list boxes so they only include values that are present in the current source
data? The list box continues to show values that are no longer in the data
set.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info