I don't think you can force it.

But you could select each pivottable, then open the wizard and go back to where
you specified the range and change it there.

But you may want to consider using a dynamic range that can grow and contract
based on how many rows (and columns) you're using.

Debra Dalgleish shares this:
http://contextures.com/xlNames01.html#Dynamic

If you want the columns to resize, too, you could modify her formula from this:
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)
to
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNT A(Sheet1!$1:$1))

This kind of dynamic range trusts that you don't have any empty cells in column
A or row 1 (except at the bottom and far right of the table)--and nothing under
the table or to the right, too.


Fred Smith wrote:

I have 5 pivot tables in a workbook. They all used the same source data (ie,
$a$1:$x$10000), but I decided I wanted a 6th which required a new column in the
data table.

If I create a new pivot table with the same data range as a previous one, Excel
asks me if I want to use the same data range. How do I do the reverse? How do I
update old pivot tables to use the more current range (ie, $a$1:$y$10000)?

--
Regards,
Fred

--

Dave Peterson