Thanks Tim. I did turn off screen updating but didn't even think abou
automatic calculations. However, adding that really didn't help much.
I did a count on the pivot items in the pivot field and it was 7999!
Talk about frickin' stupid :eek

--
Air_Cooled_Nu

-----------------------------------------------------------------------
Air_Cooled_Nut's Profile: http://www.excelforum.com/member.php...fo&userid=1573
View this thread: http://www.excelforum.com/showthread.php?threadid=50187