Tags: appeared, build, calculations, crash, excel, machine, microsoft, msdn, rebooted, running, software, spreadsheet, sudden, working

Excel stopped Calculations??

On Microsoft » Microsoft Excel

2,750 words with 4 Comments; publish: Thu, 22 May 2008 22:48:00 GMT; (306125.00, « »)

I'm running Excel 2000 build 9.0.272

I was working on my spreadsheet, all of a sudden it appeared to crash.

So i rebooted my machine.

When I did so, it stopped making calculations. :( Very strange (an

very bad). I can't get it to do _any_ calculations, either n th

spreadsheet I was working on or any other spreadsheet.

I can't figure out how to make it re-calculate the formulas again.

Everything is intact, my formulas, values, etc...

thank you for your help

--

Message posted from http://www.ExcelForum.com

All Comments

Leave a comment...

  • 4 Comments
    • From the menu at the top, select:

      Tools

      Options

      Click on tab marked Calculation

      Select "automatic" (it is probably set on manual right

      now)

      >--Original Message--

      >I'm running Excel 2000 build 9.0.272

      >

      >I was working on my spreadsheet, all of a sudden it

      appeared to crash.

      >So i rebooted my machine.

      >When I did so, it stopped making calculations. :( Very

      strange (and

      >very bad). I can't get it to do _any_ calculations,

      either n the

      >spreadsheet I was working on or any other spreadsheet.

      >I can't figure out how to make it re-calculate the

      formulas again.

      >Everything is intact, my formulas, values, etc...

      >thank you for your help!

      >

      >--

      >Message posted from http://www.ExcelForum.com/

      >.

      >

      #1; Thu, 22 May 2008 22:49:00 GMT
    • I figured it out. For anyone who wants to know. The options menu go

      changed when the spreadsheet crashed.

      There is an option to automatically calculate. It is the default, bu

      somehow it got changed during the crash.

      just fyi..

      --

      Message posted from http://www.ExcelForum.com

      #2; Thu, 22 May 2008 22:50:00 GMT
    • Luu,

      It gets that setting from the first workbook you open. It then applies to

      all workbooks. DOn't ask. No one knows.

      --

      Earl Kiosterud

      mvpearl omitthisword at verizon period net

      ---

      "luu980 >" <<luu980.1aj74k.excel.questionfor.info.excelforum-nospam.com> wrote in message

      news:luu980.1aj74k.excel.questionfor.info.excelforum-nospam.com...

      > I figured it out. For anyone who wants to know. The options menu got

      > changed when the spreadsheet crashed.

      > There is an option to automatically calculate. It is the default, but

      > somehow it got changed during the crash.

      > just fyi...

      >

      > --

      > Message posted from http://www.ExcelForum.com/

      >

      #3; Thu, 22 May 2008 22:51:00 GMT
    • Thank you two for your replies! I greatly appreciate the help!

      --

      Message posted from http://www.ExcelForum.com

      #4; Thu, 22 May 2008 22:52:00 GMT