how to create pivot table from existing pivot table in excel 2007

G

Guest

I want to create another pivot table from existing pivot table. I wa able to
do so in 2003. But I do not see any option where I can specify existing pivot
table name as the source for another pivot table ?
I am using Excel 2007 (beta)
 
D

Debra Dalgleish

Use the same source data, and the second pivot table will use the same
pivot cache that the first pivot table is based on.
 

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

Cannot Open Pivot Table Source File 0
Pivot Table Refresh not working properly 1
Pivot Tables 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot Table Data Source 1
Create pivot table from pivot table 1
Excel 2007 pivot table source table 1
Adding to an existing Pivot Table 7

Top