"I have 14 Pivot Tables on this report that I make fairly often".
.. if all PTs are based on the same data can you put the data in one
sheet, "name" the range that contains the data and use that range name
as the pivot table source. Whenever you change the data in the named
range and refresh, _all_ the pivot tables will show the new data.


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