Excel not recognizing formula
 

I am working in Excel and have a formula (simple add two columns and put the
result in a third column) that when I drag it down the column, the formula
put in the new cells changes to the relative row (e.g., C1= A1+B1; C2=
A2+B2...), but the value in the sum column always takes on the value of the
cell from which it was dragged. So, if I have A1 = 1 and B1 = 2; then the
formula in C1 is A1 + B1 and the result is 3. But, when I drag down column
C, no matter what values are in columns A and B, a 3 is always displayed in
column C - even though the formula is propagating correclty (Ax + Bx = Cx).
It seems that some feature has locked out the calculation or something. Can
anyone help fix this? Thanks.

Excel not recognizing formula
 

Hi,

It sounfs like calculation is set to manual.

Tools - Options - Calculation tab and select automatic

Mike

"Distribution list - Contacts Module" wrote:

I am working in Excel and have a formula (simple add two columns and put the
result in a third column) that when I drag it down the column, the formula
put in the new cells changes to the relative row (e.g., C1= A1+B1; C2=
A2+B2...), but the value in the sum column always takes on the value of the
cell from which it was dragged. So, if I have A1 = 1 and B1 = 2; then the
formula in C1 is A1 + B1 and the result is 3. But, when I drag down column
C, no matter what values are in columns A and B, a 3 is always displayed in
column C - even though the formula is propagating correclty (Ax + Bx = Cx).
It seems that some feature has locked out the calculation or something. Can
anyone help fix this? Thanks.