Thread: how to get auto update?

Hello,

In my excel, I have used some simple formulas. Now I am facing problem like after any change in excel, the result is not automatically updating. To get the updated result, I need to go to the cell & need to click "Enter". Can anyone help me out. I m using MS Excel 2002 & it is in shared condition.

Thanks in advance.

Regards,
Prsahu

Hello

Try this

Go to 'Tools'->'Optiion'->'Calculation'
Then select 'Automatic'
Than click 'OK'

Its working now....

Thanks,
Prsahu