Hi Dave,

Name your data range, apply that as the source for the pivot tables. When
the data range changes, redefine the range associated with the Name.

HTH
Bob

"Dave Eade" wrote in message
...
Hi,
I have a number of Pivot Tables that look at the same data, and produce
different views and charts.
If my Data Ranges changes [ ie I add a new column or a number of new
rows ]
I have to manually change the range for each pivot table - is there anyway
I
can define a range one [ in a cell or cells ] and then point each pivot
table
to that cell, so that when I want to change the range I only have to do it
once.

I can't point the PT to a "whole" sheet as I've got merged cells.

Thanks