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

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.
 
N

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.
 
J

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.
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top