Pivot Table - sourced from another Pivot Table

[David]

Hi,

In Excel 2007, how do I source a pivot table from another pivot table in the
same workbook? In Excel 2003 it had a function in the wizard to do this but
in 2007 it doesn't seem to.

Thanks, David.

 

[Roger Govier]

Hi David

I think you probably mean creating another PT based upon the same source
data - which reduces file size.
It depends on the route you take to create a PT.
If you choose Insert tab>Pivot Table than it will treat the source as being
different each time.
If you choose Insert tab>Table than form Table Tools>Summarise with Pivot
Table, you can create a number of PT's all based on that same source Table.