View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Purvis Mark Purvis is offline
external usenet poster
 
Posts: 1
Default 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.