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!

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

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

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