View Single Post
  #1   Report Post  
Piet
 
Posts: n/a
Default How can i set the source-data-range of pivottable2 to the source .

In order to save memory for excel files with multiple pivot-tables, I should
be able to reference to the source-data-range of pivot1 for the
source-data-range of pivot2.

Any idea how (apart from the 1-time question at first creation of the new
pivot)?