Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to create pivot table from existing pivot table in excel 2007
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to create pivot table from existing pivot table in excel2007
Use the same source data, and the second pivot table will use the same
pivot cache that the first pivot table is based on. Udayraj Dhulekar wrote: 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) -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Use the pivot wizard. The wizard can be added to the Quick Access Toolbar.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Data Source external excel file | Excel Discussion (Misc queries) | |||
Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
Excel 2007 (BETA) Missing data when doing pivot table | Excel Discussion (Misc queries) | |||
Pivot Table issue in Excel 2007 | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) |