| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables
In the new office 2007, How do you create a Pivot Table from another Pivot
Table? This was available in the wizard step 1. -- thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Tables
If you create the second pivot table from the same source data as the
first pivot table, it will automatically use the same pivot cache. Jeff wrote: In the new office 2007, How do you create a Pivot Table from another Pivot Table? This was available in the wizard step 1. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Tables
still did not see any answers or references to the question.
-- thanks! "Debra Dalgleish" wrote: If you create the second pivot table from the same source data as the first pivot table, it will automatically use the same pivot cache. Jeff wrote: In the new office 2007, How do you create a Pivot Table from another Pivot Table? This was available in the wizard step 1. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Tables
On Jun 25, 12:43 pm, Jeff wrote:
still did not see any answers or references to the question. -- thanks! "Debra Dalgleish" wrote: If you create the second pivot table from the same source data as the first pivot table, it will automatically use the same pivot cache. Jeff wrote: In the new office 2007, How do you create a Pivot Table from another Pivot Table? This was available in the wizard step 1. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html- Hide quoted text - - Show quoted text - Debra, I think what he did was create a pivot table directly from a query rather than pull the data back into a sheet. Then he wants to make another pivot table using the first pivot table as the source rather than rerunning the query. I gave up doing this a long time ago. I always pull the data into a sheet and make the pivot table using the data sheet as the source. Am I understanding your question Jeff? Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
| Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
| Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
| how do I consolidate multiple pivot tables into one pivot table? | Excel Discussion (Misc queries) | |||
| How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
![Jeff[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
