Formulas Stopped Working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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?
 
Back
Top