Use the same source data, and the second pivot table will use the same
pivot cache that the first pivot table is based on.
Udayraj Dhulekar wrote:
I want to create another pivot table from existing pivot table. I wa able to
do so in 2003. But I do not see any option where I can specify existing pivot
table name as the source for another pivot table ?
I am using Excel 2007 (beta)
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html