Excel 07 formulas on a whole spread sheet stopped working

[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?

 

[Hank Scorpio]

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

 

[Gord Dibben]

Sounds like calculation has been set to manual.

Go into Options and set it to automatic.


Gord Dibben MS Excel MVP