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?

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

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 wrote:
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

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

SteveF wrote:
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 wrote:

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




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