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

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

Tools--Options--Calculation--Automatic

Your calculation settings are set to manual.

Dave
--
Brevity is the soul of wit.


"riggi" wrote:

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

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

On Jan 30, 12:38 pm, "M. Authement" wrote:
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- Hide quoted text -

- Show quoted text -

Thanks guys .. it worked!