Excel 2007 - Create Pivot table from another pivot table

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?
 
G

Guest

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
 
D

Debra Dalgleish

In Excel 2007, if you use the same source data, it should automatically
use the same pivot cache.
 
E

Ed Hansberry, MS-MVP/Mobile Devices

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?

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? -
 

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

Top