function execution

  • Thread starter Thread starter matty_g
  • Start date Start date
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?
 
Are you sure you don't have calculation set to Manual (Tools | Options)?
 
Tools>options>calculation set calculations to automatic

Regards,

Peo Sjoblom
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

want to track time while paste value in multiple column of same roe 1
Excel Excel 2013 cell text hidden whilst typing 5
Excel functions do not execute 2
function execution 11
Excel VBA 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Creating Function to Reference Cells that Contain Certain Values 5
Excel code, end function? 0

Back
Top