MS Excel 2003 cannot auto calculate formula, need to press F9 eachtime

[sg_s123]

hi,

I don't know why my excel 2003 new worksheet cannot auto calulate
formula (eg. summation), i need to press F9 and it will refresh and
show the new figure. there is "calculate" word at the left hand bottom
of the screen.

what is the likely reason ? it was running fine 2 weeks ago.

any advise is greatly appreciated.

rgds.

 

[Niek Otten]

Tools>Options>Calculation tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| hi,
|
| I don't know why my excel 2003 new worksheet cannot auto calulate
| formula (eg. summation), i need to press F9 and it will refresh and
| show the new figure. there is "calculate" word at the left hand bottom
| of the screen.
|
| what is the likely reason ? it was running fine 2 weeks ago.
|
| any advise is greatly appreciated.
|
| rgds.

 

[Jim Rech]

You didn't happen to check "Iteration" on the Options, Calculation dialog?

--
Jim
| hi,
|
| I don't know why my excel 2003 new worksheet cannot auto calulate
| formula (eg. summation), i need to press F9 and it will refresh and
| show the new figure. there is "calculate" word at the left hand bottom
| of the screen.
|
| what is the likely reason ? it was running fine 2 weeks ago.
|
| any advise is greatly appreciated.
|
| rgds.

 

[sg_s123]

You didn't happen to check "Iteration" on the Options, Calculation dialog?

--

| hi,
|
| I don't know why my excel 2003 new worksheet cannot auto calulate
| formula (eg. summation), i need to press F9 and it will refresh and
| show the new figure. there is "calculate" word at the left hand bottom
| of the screen.
|
| what is the likely reason ? it was running fine 2 weeks ago.
|
| any advise is greatly appreciated.
|
| rgds.

hi,

I check that it is check automatic when click
Tools>Options>Calculation tab

i did not check iteration box.

but somehow the problem is intermitten.