![]() |
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 |
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.
|
there has to be a way to turn it off
|
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. |
|
Quote:
|
| 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