I have found the answer!
Most instruction books do not specifically mention the word 'iterations'
ToolsoptionsCalculationuncheck 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!!