quick question
 

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

quick question
 

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

quick question
 

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

quick question
 

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

quick question
 

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!