View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Oren Oren is offline
external usenet poster
 
Posts: 1
Default Updating Pivot Tables

I have about 20 pivot tables all based on the same pivot cache. If I update
the pivot cache (i.e. add 1000 rows) can I update all of the pivot tables
simultaneously. It is quite labor-intensive to update each pivot table
separately.