Formulas not working

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amanda003 - 05 Feb 2008 23:30 GMT

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.

Reply to this Message

Tyro - 05 Feb 2008 23:46 GMT

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

>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
[quoted text clipped - 5 lines]
> to get the correct total. Can anyone tell me why it suddenly stopped
> working.

Reply to this Message

Max - 05 Feb 2008 23:54 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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

Reply to this Message

Gord Dibben - 06 Feb 2008 00:09 GMT

Tools>Options>Calculation.

Is it set to Automatic?

Gord Dibben MS Excel MVP

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

Reply to this Message