Excel Help

Reply #5

hypersoniq — Tue, 28 Feb 2006 04:10:35 GMT

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.

Reply #4

CARBOB — Mon, 27 Feb 2006 22:58:19 GMT

It disappeared, gone. Problem solved.

Bob

Reply #3

lottaloot — Mon, 27 Feb 2006 22:46:51 GMT

Thanks. : )

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

Reply #2

CARBOB — Mon, 27 Feb 2006 22:44:35 GMT

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

Reply #1

lottaloot — Mon, 27 Feb 2006 22:41:06 GMT

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

Excel Help

CARBOB — Mon, 27 Feb 2006 22:34:13 GMT

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