Excel 2003: Cell calculation not automatically updating.

[jwxpnd]

This problem has occurred recently.

I have 3 cell. Cells A and B are the numbers to be added together and cell C is the result it calculates of cells A and B

Normally all I have to do is change the number of one of the first 2 cells and the third cell is automatically updated.
BUT, now when I enter data in cell A or B, I have to double click and hit enter on cell C to get cell C to update.

How do I make it go back to automatically updating cell C?

THANKS!

 

[SkipVought]

Hi,

Check Tools > Options - Calculation Tab: AUTOMATIC

Skip,

_{Just traded in my old subtlety...
for a brand NUANCE!}

 

[jwxpnd]

Thank you Skip! That worked.