Formulas not working

[Amanda003]

I have a budget template saved on my computer at work it worked fine
yesterday and I emailed it to my house. The one I emailed works fine. I go
back today to the one saved at work and none of the formulas will calculate
by them selves. If I change something I have to click the auto add each time
to get the correct total. Can anyone tell me why it suddenly stopped
working.

 

[Tyro]

Sounds like your workbook is in manual calculations mode. Look in your
options and change the calculation mode from manual to automatic. Prior to
Excel 2007, that is in Tools/Options. In Excel 2007 it's under formulas in
the options.

Tyro

 

[Max]

Check/ensure that the calc mode is set to Automatic
Click Tools > Options > Calculation tab > Check "Automatic" > OK

 

[Gord Dibben]

Tools>Options>Calculation.

Is it set to Automatic?


Gord Dibben MS Excel MVP