Pivot Table - sourced from another Pivot Table

D

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.
 
R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Pivot table 1
How to base a pivot table on another pivot table? 3
Excel 2007 - Create Pivot table from another pivot table 6
Pivot Table Help! 1
Pivot table report invalid 0
Excel 2010 Slicer Connection / Pivot Table Problem 3
PIvot Table top Values 1
making an excel table visible for external data on pivot table 1

Top