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