Welcome Guest
Log In | Register )
You last visited January 21, 2017, 10:16 am
All times shown are
Eastern Time (GMT-5:00)

Excel Help

Topic closed. 5 replies. Last post 11 years ago by hypersoniq.

Page 1 of 1
PrintE-mailLink
CARBOB's avatar - FL LOTTERY_LOGO.png
ORLANDO, FLORIDA
United States
Member #4924
June 3, 2004
5975 Posts
Online
Posted: February 27, 2006, 5:34 pm - IP Logged

I have a problem with the "calculate" showing on the bottom of my screen. It wasn't there before I dragged and filled a lot of cells. Now, when I enter something in a cell it recalculates. Any suggestions.

Carbob

    lottaloot's avatar - AvatarZ56
    Redford/MI
    United States
    Member #3396
    January 18, 2004
    4867 Posts
    Offline
    Posted: February 27, 2006, 5:41 pm - IP Logged

    Don't quite know what you're saying. 

    Are you trying to get around the re-calc until you're ready to save your work? 

    I know it is under options in excel but my sheets are recalculating now & I can't get to the info.

     

    Play around with it |=) 

     

    L ttaL   T

      CARBOB's avatar - FL LOTTERY_LOGO.png
      ORLANDO, FLORIDA
      United States
      Member #4924
      June 3, 2004
      5975 Posts
      Online
      Posted: February 27, 2006, 5:44 pm - IP Logged

      No Kim, It wasn't there before Idid the drag and fill. As soon as I did that, it jumped on. BTW, nice pictures of your family.

      Bob

        lottaloot's avatar - AvatarZ56
        Redford/MI
        United States
        Member #3396
        January 18, 2004
        4867 Posts
        Offline
        Posted: February 27, 2006, 5:46 pm - IP Logged

        Thanks.  : )

        Wish I could help you; but as I have said, my sheets are in calc mode at the moment. 

        L ttaL   T

          CARBOB's avatar - FL LOTTERY_LOGO.png
          ORLANDO, FLORIDA
          United States
          Member #4924
          June 3, 2004
          5975 Posts
          Online
          Posted: February 27, 2006, 5:58 pm - IP Logged

          It disappeared, gone. Problem solved.

          Bob

            hypersoniq's avatar - 8ball
            Pennsylvania
            United States
            Member #1340
            April 6, 2003
            2450 Posts
            Offline
            Posted: February 27, 2006, 11:10 pm - IP Logged

            tools:options:calculation

            that's where you can control the behavior of the autocalculate feature.

            you can pick automatic/manual (using the F9 key)/manual with autorecalc on exit.

            sometimes copying/pasting large amountsof data causes it to hang "in limbo" until the program catches up... it eventually does tho.

            Playing more than one ticket per game is betting against yourself.