Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL 2003 Why have my formulae stopped working uncomplicated work
Hi John,
Try: Tools | Calculation | Check the Aotomatic option. --- Regards, Norman "John Baker - Rustington" <John Baker - wrote in message ... 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!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL 2003 Why have my formulae stopped working uncomplicated work
"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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL 2003 Why have my formulae stopped working uncomplicated work
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft office excel 2003 has stopped working | Excel Discussion (Misc queries) | |||
Excel 2003 Simply Stopped Working | Excel Worksheet Functions | |||
Edit / Move or copy sheet stopped working in Excel 2003 | Excel Worksheet Functions | |||
Hyperlinks stopped working in Excel 2003 | Excel Discussion (Misc queries) | |||
vba project stopped working in excel 2003 | Excel Programming |