Remove old selections in Pivottable row field dropdown list

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.

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

Debra Dalgleish's site.

--
Regards,
Tom Ogilvy


"Mark Purvis" <Mark [email protected]> wrote in message
news:[email protected]...
> 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.