Excel 2007 - Create Pivot table from another pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excel 2003, if I had a pivot table open, I could go to a new workshhet,
create a new pivot table and one of the choices for the source data would be
another pivot table in this workbook. This would create a new pivot table
using the same pivot table cache.
I can't seem to find the equivalent functionality in Excel 2007.
Can this still be done?
 
Thanks for the reply.

This is really too bad as this was a very useful function. Fortunately, it's
not too hard to write a macro to do it. This is OK for me but our users will
be a bit put off.

Tom
 
In Excel 2007, if you use the same source data, it should automatically
use the same pivot cache.
 
Tom Bergman said:
In Excel 2003, if I had a pivot table open, I could go to a new workshhet,
create a new pivot table and one of the choices for the source data would be
another pivot table in this workbook. This would create a new pivot table
using the same pivot table cache.
I can't seem to find the equivalent functionality in Excel 2007.
Can this still be done?
Click to expand...

Yes. Add the "Pivot Table Wizard" to the Quick Access Bar.
(Select "All Commands" in the customize screen and look for
"PivotTable and ChartTable Wizard.)

Now select a blank cell, click the Wizard in the tool bar and go
from there.

--
__________________________________________________________________________________
Ed Hansberry (Please do *NOT* email me. Post here for the benefit of all)
What is on my Pocket PC? http://www.ehansberry.com/
Microsoft MVP - Mobile Devices www.pocketpc.com
What is an MVP? -
 
Back
Top