ExcelBanter - How can i set the source-data-range of pivottable2 to the source .

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can i set the source-data-range of pivottable2 to the source . (https://www.excelbanter.com/excel-discussion-misc-queries/16267-how-can-i-set-source-data-range-pivottable2-source.html)

Piet

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)?

All times are GMT +1. The time now is 06:41 PM.