function execution

M

matty_g

Hello,

I have a cell with an an if statement in it. The data in this cell is
dependant upon other cells. The problem I am having is that I inorder
to get the function to execute once I have entered data in the
dependant cells, I have to double click on the cell then hit enter.
Where as in other cells (example: a simple multiplication cell) it
updates it automatically when the a cell loses focus. Is there anyway
I can get this function to execute when a cell looses focus?
 
V

Vasant Nanavati

Are you sure you don't have calculation set to Manual (Tools | Options)?
 
P

Peo Sjoblom

Tools>options>calculation set calculations to automatic

Regards,

Peo Sjoblom
 
Top