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 Basing a Pivot Table on Another Pivot Table

You can use the same data range that an existing pivot table is based
on, or copy and paste an existing pivot table.

Ken wrote:
In Excel 2003, I was able to use another Pivot Table in the Worksheet as a
Data Source. In Excel 2007 I can't figure out how to do it.

Any ideas?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html