View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default How can you have two pivot tables on one worksheet?

To uncouple multiple PivotTables,
convert the common source List/Table into a range and
give the same range two or more different defined names.
(Include header range)
Go to the source definition for each PT
and enter a different source name for each PT.
Turn the source range back into a
Excel 2007 Table or Excel 2003 List.