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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sg_s123@yahoo.com.sg - 01 Apr 2008 10:36 GMT

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.

Reply to this Message

Niek Otten - 01 Apr 2008 11:34 GMT

Tools>Options>Calculation tab, check Automatic

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| hi,
|
[quoted text clipped - 8 lines]
|
| rgds.

Reply to this Message

Jim Rech - 01 Apr 2008 11:38 GMT

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

Signature

Jim

| hi,
|
[quoted text clipped - 8 lines]
|
| rgds.

Reply to this Message

sg_s123@yahoo.com.sg - 01 Apr 2008 12:04 GMT

> You didn't happen to check "Iteration" on the Options, Calculation dialog?
>
[quoted text clipped - 14 lines]
> |
> | 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.

Reply to this Message