Excel 2007 Pivot Table

[SteveF]

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]

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]

Thanks Debra, guess I was not paying attention to what the ribbon was
changung to when I selected a cell in the pivot table

 

[Debra Dalgleish]

You're welcome. So much has changed that it's hard to find all the features.

Thanks Debra, guess I was not paying attention to what the ribbon was
changung to when I selected a cell in the pivot table