Excel 07 formulas on a whole spread sheet stopped working

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have been using Excel for ages now with a spread sheet that includes
formulas that have worked fine. Now when I put in values for the formula to
use I have to go onto the cell that contains the formula, put my cursor at
the end of the formula in the top cell box and then press enter to get the
formulas to work every time. Why has it stopped doing it automatically?
 
I have been using Excel for ages now with a spread sheet that includes
formulas that have worked fine. Now when I put in values for the formula to
use I have to go onto the cell that contains the formula, put my cursor at
the end of the formula in the top cell box and then press enter to get the
formulas to work every time. Why has it stopped doing it automatically?
Click to expand...

I'm not sure whether this is the same in 2007 (which I avoid if I
can), but in earlier versions there were occasions whe the dependency
treee would get screwed up. Forcing a rebuild by pressing [Ctrl] +
[Alt] + [Shift] + [F9] would often sort it out.

Worth a try.
 
Sounds like calculation has been set to manual.

Go into Options and set it to automatic.


Gord Dibben MS Excel MVP
 
Back
Top