any excel experts out there? Question - GoFuckYourself.com

flashfire · 06-06-2006, 03:54 PM

Hey, I input my daily stats data in excel and it calculates daily totals, weekly totals, and monthly totals for all programs combined. My problem is that every time I enter some info it takes 10-15 secs to "calculate cells" is there anyway I can disable this until I'm finished and then calculate it all at ounce?

thanx

Sparks · 06-06-2006, 03:56 PM

I am not aware of anyway to do that. I have similar problems with some of my larger excel files. Guess it's just sort of like logs processing, just takes time.

flashfire · 06-06-2006, 03:57 PM

there has to be a way to turn it off

spasmo · 06-06-2006, 04:03 PM

Go to Tools -> Options -> Calculation

Click the radio button for Manual and click OK. From here on out you'll have to hit F9 to recalculate, but you can always change it back to Automatic.

OzMan · 06-06-2006, 04:15 PM

I think this is basically what spasmo said

http://support.microsoft.com/kb/839951/en-us

flashfire · 06-06-2006, 05:33 PM

Quote:

Originally Posted by spasmo

Go to Tools -> Options -> Calculation

Click the radio button for Manual and click OK. From here on out you'll have to hit F9 to recalculate, but you can always change it back to Automatic.

sweeeeeeet! thanx guys

06-06-2006, 03:54 PM	#1
flashfire ICQ 1 6 7 8 5 3 4 9 2 Join Date: Feb 2003 Posts: 13,098	any excel experts out there? Question Hey, I input my daily stats data in excel and it calculates daily totals, weekly totals, and monthly totals for all programs combined. My problem is that every time I enter some info it takes 10-15 secs to "calculate cells" is there anyway I can disable this until I'm finished and then calculate it all at ounce? thanx

06-06-2006, 04:03 PM	#4
spasmo Confirmed User Join Date: Dec 2005 Location: Couch Posts: 2,678	Go to Tools -> Options -> Calculation Click the radio button for Manual and click OK. From here on out you'll have to hit F9 to recalculate, but you can always change it back to Automatic. __________________ Surfers: Go here for hot babes.

06-06-2006, 03:56 PM	#2
Sparks Confirmed User Join Date: Nov 2004 Location: Southern CA Posts: 2,466	I am not aware of anyway to do that. I have similar problems with some of my larger excel files. Guess it's just sort of like logs processing, just takes time.

06-06-2006, 03:57 PM	#3
flashfire ICQ 1 6 7 8 5 3 4 9 2 Join Date: Feb 2003 Posts: 13,098	there has to be a way to turn it off

06-06-2006, 04:15 PM	#5
OzMan Confirmed User Join Date: Sep 2003 Location: Los Begas Posts: 9,162	I think this is basically what spasmo said http://support.microsoft.com/kb/839951/en-us