GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)
-   Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)
-   -   any excel experts out there? Question (https://gfy.com/showthread.php?t=618544)

flashfire 06-06-2006 03:54 PM

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

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


All times are GMT -7. The time now is 02:24 PM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2026, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc123