You do not say if all the pivots are from the same dataset.
If it is, and the data is in a named range [insert name define], if
you refresh one pivot table then all are updated. Is this what you mean?


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=566504