quick question

R

riggi

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
 
D

Dave F

Tools--Options--Calculation--Automatic

Your calculation settings are set to manual.

Dave
 
M

M. Authement

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

riggi

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






- Show quoted text -
Click to expand...

Thanks guys .. it worked!
 
Top