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