Create pivot table from pivot table

[Guest]

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?

 

[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