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