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.

Remove old selections in Pivottable row field dropdown list
 

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.