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?


--
matty_g
------------------------------------------------------------------------
matty_g's Profile: http://www.excelforum.com/member.php...o&userid=23954
View this thread: http://www.excelforum.com/showthread...hreadid=377525

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

--

Vasant

"matty_g" wrote in
message ...

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?


--
matty_g
------------------------------------------------------------------------
matty_g's Profile:
http://www.excelforum.com/member.php...o&userid=23954
View this thread: http://www.excelforum.com/showthread...hreadid=377525

Toolsoptionscalculation set calculations to automatic

Regards,

Peo Sjoblom

"matty_g" wrote:


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?


--
matty_g
------------------------------------------------------------------------
matty_g's Profile: http://www.excelforum.com/member.php...o&userid=23954
View this thread: http://www.excelforum.com/showthread...hreadid=377525