I've been working on a new spreadsheet for several weeks. All of the
formulas stopped working in it today. I opened some other Excel files and
they stopped working as well.

If I change a value in a cell that the formula cell should calculate, it
doesn't change. HOWEVER, if I double click on the formula cell, then enter,
it calculates.

Any clue as to what's happening?

Set the calc "switch" to Auto!

<Tools <Options <Calculation tab.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"djcircman" wrote in message
...
I've been working on a new spreadsheet for several weeks. All of the
formulas stopped working in it today. I opened some other Excel files and
they stopped working as well.

If I change a value in a cell that the formula cell should calculate, it
doesn't change. HOWEVER, if I double click on the formula cell, then enter,
it calculates.

Any clue as to what's happening?

Tools/Options/Calculate. Select Automatic.

In article ,
djcircman wrote:

I've been working on a new spreadsheet for several weeks. All of the
formulas stopped working in it today. I opened some other Excel files and
they stopped working as well.

If I change a value in a cell that the formula cell should calculate, it
doesn't change. HOWEVER, if I double click on the formula cell, then enter,
it calculates.

Any clue as to what's happening?