Hi
Create a Dynamic range for your data, and use the name of the range as
the data source for your PT.
For help on constructing a named dynamic range take a look at Debra
Dalgleish's site
http://www.contextures.com/xlNames01.html#Dynamic
--
Regards
Roger Govier
"anandmr65"
wrote in message
...
Hi,
I have used the same data for multiple pivot tables. The Data keeps on
changing and the rows gets added and deleted. So everytime I have to
go
to all the pivot table and change the Datasource range.
Is there anymethod that can be used, which will automatically adjust
the datasource range for all the pivots without intervetion.
Please educate.
Thanks & Regards
Anand
--
anandmr65
------------------------------------------------------------------------
anandmr65's Profile:
http://www.excelforum.com/member.php...o&userid=30728
View this thread:
http://www.excelforum.com/showthread...hreadid=559203