Hi Nort

frustration isn't it ... check out "dynamic ranges, naming" at
www.contextures.com/tiptech.html
for an solution

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Nort" wrote in message
...
I add new data to the data range weekly. To get the (6) pivot tables which
look at the data to update and include the new lines, I have to go into
the
wizard and redefine the data range for each pivot. There must be an
easier
way.