how to update cell value with fx.?

[jay11]

hi
in my work sheet cell D10 i have function =IF(C23>0,$C$15,"") and anther function in diff cell.
but it don't update the value of D10 but i find that if i save the sheet than it update the value in cell D10 .
so what i have to do? to make this work without saving the sheet but as soon as i enter the value in cell C15 and C23 and tab the cell it update the value in cell
it use to work likewise but now i have to select the cell and enter to up date the cell value
i have some module in work sheet does it interfere for this?
pl any help is greatly appreciated

[JBeaucaire]

Check your Tools > Options > Calculation and make sure it is set to Automatic.

Also you can press F9.

[jay11]

thanks JB
it work