View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default how to create pivot table from existing pivot table in excel2007

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