Hi AlynnS,

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

Ed Ferrero

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?