Formula won't update

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

D - 29 Apr 2007 15:42 GMT

I have a number of spreadsheets with formulae that I have been using for
years. For no apparent reason, the formulae no longer update themselves when
I enter new data.

They do work if I press 'Save'.

I would be very grateful for any suggestions as to what has caused this, and
how to resolve the problem.

Reply to this Message

Roger Govier - 29 Apr 2007 15:47 GMT

Hi

It sounds as though Calculation has switched to Manual

Tools>Options>Calculation>tick automatic

The mode gets set by the setting of the first workbook you open in a
session. It probably means that the first workbook you have started
opening now, is set to Manual, that is why the behaviour has altered.
Set that one to Automatic, save it and then you should be OK.

Signature

Regards

Roger Govier

>I have a number of spreadsheets with formulae that I have been using
>for
[quoted text clipped - 7 lines]
> this, and
> how to resolve the problem.

Reply to this Message

D - 29 Apr 2007 16:26 GMT

A thousand thanks -that worked perfectly! Any ideas why the first sheet set
itself to 'manual'?

> Hi
>
[quoted text clipped - 18 lines]
> > this, and
> > how to resolve the problem.

Reply to this Message

Bernard Liengme - 29 Apr 2007 20:21 GMT

Maybe you opened another workbook with this setting on.
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>A thousand thanks -that worked perfectly! Any ideas why the first sheet
>set
[quoted text clipped - 22 lines]
>> > this, and
>> > how to resolve the problem.

Reply to this Message

Rate this thread: