toolsoptionscalculation
BTW you don't need ( )
=k6/5 will do

--
Don Guillett
SalesAid Software

"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