Thanks for the toolbar tip, but that does not work for me.

Perhaps the problem is that I have independant pivot-tables on each
page (they all use the same source data though). When I created them I
selected "No" when the prompt came up telling me it would be more more
efficient and require less memory to base them on existing pivot
tables.

I still have to go through each work-sheet and click the Exclamation
Point button to update.

Strangely enough, the refresh button on my toolbar doesnt work for
pivot-charts, only pivot tables....


--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: http://www.excelforum.com/member.php...fo&userid=7092
View this thread: http://www.excelforum.com/showthread...hreadid=533761