logical test not working

Hello All,

I inserted the following logical tests for cells E5 and E6. I saved the workbook with SE(B) in cell G3.

Please Login or Register  to view this content.

Now when I open the worksheet and change the value in G3 to C(T) it does not changes the cells E5 and E6 automatically. I have to press return key after clicking on these cells to set them to the right value. And there are many other cells that work on the similar logical test and none of them is working now.

Can someone help me with this problem..I think I saved it once with one of the options and thats the reason for it not working now. Infact, I have cleared all cells and done it all over again but still no response. I cannot rebuild the whole file as its too big with other functions and graphs .

need to set this problem right

thanks in advance,
arora

Hi

Chek you have automatic Calculation turned on:

Tools>options>Calculation tab in xl2003 and below.

Office button>ExcelOptions>Formulas in xl2007

Check Tools > Options > Calculation. setting is automatic rather than manual.