Show the pivottable wizard for that pivottable.

Hit the back button as many times as you need to get to the step that asks you
for the range.

If the range grows and contracts rows, you may want to create a dynamic range
name so all you have to do is refresh the pivottable.

Debra Dalgleish shares instructions for that kind of dynamic name:
http://contextures.com/xlNames01.html#Dynamic

Fred Smith wrote:

I've added data to my pivot table, and want to change the data range. How do
I do this in Excel 2007?

Thanks,
Fred

--

Dave Peterson