J
Jeff
In the new office 2007, How do you create a Pivot Table from another Pivot
Table? This was available in the wizard step 1.
Table? This was available in the wizard step 1.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Debra Dalgleish
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.
first pivot table, it will automatically use the same pivot cache.
J
Jeff
still did not see any answers or references to the question.
P
par_60056
still did not see any answers or references to the question.
--
thanks!
- 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