Excel stopped Calculations???

[luu980]

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

 

[alise]

From the menu at the top, select:
Tools
Options
Click on tab marked Calculation
Select "automatic" (it is probably set on manual right
now)

 

[luu980]

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..

 

[Earl Kiosterud]

Luu,

It gets that setting from the first workbook you open. It then applies to
all workbooks. DOn't ask. No one knows.

 

[luu980]

Thank you two for your replies! I greatly appreciate the help!