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

  • Thread starter Thread starter sg_s123
  • Start date Start date
S

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.
 
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.
 
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.
 
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.
Click to expand...

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.
 
Back
Top