any excel experts out there? Question

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • flashfire
    ICQ 1 6 7 8 5 3 4 9 2
    • Feb 2003
    • 13098
    #1

    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
    Tags: None
    • Sparks
      Confirmed User
      • Nov 2004
      • 2466
      #2
      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.

        Comment

        • flashfire
          ICQ 1 6 7 8 5 3 4 9 2
          • Feb 2003
          • 13098
          #3
          there has to be a way to turn it off

            Comment

            • spasmo
              Confirmed User
              • Dec 2005
              • 2678
              #4
              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.

                Comment

                • OzMan
                  Confirmed User
                  • Sep 2003
                  • 9162
                  #5
                  I think this is basically what spasmo said

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

                    Comment

                    • flashfire
                      ICQ 1 6 7 8 5 3 4 9 2
                      • Feb 2003
                      • 13098
                      #6
                      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

                        Comment

                        Previous template Next
                        Working...