The calculation mode may be in manual. Check Tools, Options, Calculations
tab and make sure Automatic is selected.


"riggi" wrote in message
ups.com...
I have a inserted a formula in a cell and have given another cell
reference to it. For example, F3 = (K6/5), when user enter a value in
K6 , the cell F3 doesn't automatically get the new value. I have to
click cell F3 and hit enter to update the new value. Why so?? Is there
a way to make it automatic?

Thanks,

Riggi