View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
HKaplan HKaplan is offline
external usenet poster
 
Posts: 80
Default Pivot Table Drop Downs

One fast answer is to create a macro that generates the pivot table.
When you open a new data set, run the macro, and it will create a
fresh table.