Formulas not working

A

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

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
 
M

Max

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

Gord Dibben

Tools>Options>Calculation.

Is it set to Automatic?


Gord Dibben MS Excel MVP
 
Top