Share

Excel Help

CARBOB's avatar - ga lottery.png.gif

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

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 |=) 

 

CARBOB's avatar - ga lottery.png.gif

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

Thanks.  : )

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

CARBOB's avatar - ga lottery.png.gif

It disappeared, gone. Problem solved.

Bob

hypersoniq's avatar - binary

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.

TopEnd of thread (1 page)

Welcome Guest

Your last visit: Sun, Oct 25, 2020, 11:48 am

Log In

Log InCancel

Forgot your username?

Forgot your password?