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.

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

"Amanda003" wrote in message
...
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.

Check/ensure that the calc mode is set to Automatic
Click Tools Options Calculation tab Check "Automatic" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Amanda003" wrote:
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.

ToolsOptionsCalculation.

Is it set to Automatic?


Gord Dibben MS Excel MVP

On Tue, 5 Feb 2008 15:30:00 -0800, Amanda003
wrote:

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.