To change the data source in Excel 2007:

Select a cell in the pivot table
On the Ribbon, click PivotTable Tools
Click Options, then click Change Data Source
Select Change Data Source
Enter the new data source, click OK

SteveF wrote:
In earlier versions of Excel, if you right clicked on a pivot table you
could invoke the pivot table wizard, hit the "back" button and modify
(expand or contract) the range that the pivot table was based on (if
you did not have the foresight to use a dynamic range to begin with)

Can something similar be done in Excel 2007?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html