Hi,

I have some 8 pivot table that looks at one data table. This data table
needs to be updated manually very frequently. Now every time this data
table changes, all the pivot table need to be refreshed automatically.
If I use the refresh on open option, then the workbook need to be
closed & opened.

Is there a way where the pivot table gets refreshed as and when the
data changes in data table.

Please let me know.

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=560160

You could set the on_change event for the worksheet with the data table
on it to refresh the pivot tables. If you make pivot tables 2-8 linked
to the original pivot table, then you only have to refresh one for them
all to work

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=560160