Thread: How can I use a pivot table as source for a second table?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
  
Posts: 2,276
Default How can I use a pivot table as source for a second table?
Hi,
Highlight the pivot table, press CTRL + C, go to where you want the new
Pivot T, press CTRL V, change parameters, when you update the other PT it
will update this one

"Rene" wrote:

In XL 2003 you could select another pivot table as source data for a second
pivot table. How do you do this for XL 2007?
Reply With QuoteReply With Quote