Create pivot table from pivot table

A

AlynnS

In the Change Datasource I'm not seeing a list of existing pivot tables to
choose from like I used to see in Excel 2003 - how do I create a pivot table
based on an existing pivot table that will automatically refresh when the
original one does?
 
E

Ed Ferrero

Hi AlynnS,

I assume you are using Excel 2007. Use Alt-D-P to get the 2003 style Pivot
Table Wizard.

Ed Ferrero
 
Top