EXCEL 2003 Why have my formulae stopped working uncomplicated work

I am the treasurer of my local methodist church.I Have used the same spread
sheet for the last three years. In the last three weeks and eleven months
into the financial year the various formulae have stopped updating the
various totals. If I amend the formula my even only one element and confirm
the total will update, but this does not right the position the next time I
add a new entry.
Help!!

Hi John,

Try:

Tools | Calculation | Check the Aotomatic option.


---
Regards,
Norman



"John Baker - Rustington" <John Baker -
[email protected]> wrote in message
news:[email protected]...
>I am the treasurer of my local methodist church.I Have used the same spread
> sheet for the last three years. In the last three weeks and eleven months
> into the financial year the various formulae have stopped updating the
> various totals. If I amend the formula my even only one element and
> confirm
> the total will update, but this does not right the position the next time
> I
> add a new entry.
> Help!!

"John Baker - Rustington" wrote:

> I am the treasurer of my local methodist church.I Have used the same spread
> sheet for the last three years. In the last three weeks and eleven months
> into the financial year the various formulae have stopped updating the
> various totals. If I amend the formula my even only one element and confirm
> the total will update, but this does not right the position the next time I
> add a new entry. REPLY TO Norman Jones.
Followed suggestion 'automatic' 'circle' already checked! Presumably Norman
is not suggesting the one below. Not sure I know what an .'iteration' is. My
BIBLE doesn't even mention the term
Thank you however

I have found the answer!
Most instruction books do not specifically mention the word 'iterations'
Tools>options>Calculation>uncheck the iteration box.
That rather 'simple' operationb restored the formulae immediately.
Thanks
John Baker 3 August 2006

"John Baker - Rustington" wrote:

> I am the treasurer of my local methodist church.I Have used the same spread
> sheet for the last three years. In the last three weeks and eleven months
> into the financial year the various formulae have stopped updating the
> various totals. If I amend the formula my even only one element and confirm
> the total will update, but this does not right the position the next time I
> add a new entry.
> Help!!

I have found the answer!
Most instruction books do not specifically mention the word 'iterations'
Tools>options>Calculation>uncheck the iteration box.
That rather 'simple' operationb restored the formulae immediately.
Thanks
John Baker 3 August 2006

"John Baker - Rustington" wrote:

> I am the treasurer of my local methodist church.I Have used the same spread
> sheet for the last three years. In the last three weeks and eleven months
> into the financial year the various formulae have stopped updating the
> various totals. If I amend the formula my even only one element and confirm
> the total will update, but this does not right the position the next time I
> add a new entry.
> Help!!

I have found the answer!
Most instruction books do not specifically mention the word 'iterations'
Tools>options>Calculation>uncheck the iteration box.
That rather 'simple' operationb restored the formulae immediately.
Thanks
John Baker 3 August 2006

"John Baker - Rustington" wrote:

> I am the treasurer of my local methodist church.I Have used the same spread
> sheet for the last three years. In the last three weeks and eleven months
> into the financial year the various formulae have stopped updating the
> various totals. If I amend the formula my even only one element and confirm
> the total will update, but this does not right the position the next time I
> add a new entry.
> Help!!