Pivot Table Calculation
 

Hi all,

I have a Macro that updates values in a pivot table - but it takes to
long to run the macro as the Pivot Table needs to re-calculat
everytime a field is updated - how can I turn off this option, and the
refresh the pivot table at the end of the macro?

TIA

Joe

--
gti_jober
-----------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...fo&userid=3063
View this thread: http://www.excelforum.com/showthread.php?threadid=56062