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

Debra Dalgleish's site.

--
Regards,
Tom Ogilvy


"Mark Purvis" <Mark wrote in message
...
I am using a PivotTable to display data from an Access Database. As the
data
changes I am unable to remove the old values in the row field dropdown
lists.
This list grows expoentially making navigation through the list
difficult.
Since I update the Pivot table via a macro, I am looking for a way to
reset
the row field dropdown list to only reflect the values in the data that is
imported to the pivot table.