Pivot Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In the new office 2007, How do you create a Pivot Table from another Pivot
Table? This was available in the wizard step 1.
 
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.
 
still did not see any answers or references to the question.
--
thanks!





- Show quoted text -
Click to expand...

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
 
Back
Top