Copy formula down - cell references change - result is same for al

[ace]

Hello,

I am having this problem:

1. I enter this formula in cell D1: A1 + B1 - C1
2. The result is 10
3. I copy the formula down the column
4. All the results in column D are 10 even though the cell references are
adjusted for the new row

Help!
Thanks!

 

[Glenn]

Hello,

I am having this problem:

1. I enter this formula in cell D1: A1 + B1 - C1
2. The result is 10
3. I copy the formula down the column
4. All the results in column D are 10 even though the cell references are
adjusted for the new row

Help!
Thanks!

Check that calculation is set to automatic.

 

[T. Valko]

Make sure calculation is set to automatic.

Excel 2007:

Formulas tab>Calculation>Calculation Options>Automatic

All other versions of Excel:

Tools>Options>Calculation tab>Automatic>OK

 

[Mike H]

Hi,

My guess is that calculation has been turned to manual. Do the formula
update if you tap F9?

If so
E2003
Tools|Options - Calculation tab and select automatic

E2007
Office button - Excel options - Formulas and select automatic

Mike

 

[kepetersen3405]

Do you have auto or manual calculate on the spreadsheet? Go to tools,
options, calculation and see what your settings are. You may need to change
it to Automatic Calculation.

 

[ace]

Thanks to all of you smart people who knew the answer to my problem. It was
in fact the manual setting in the formula options. My next question is, how
did it get set to Manual?

 

[Glenn]

Thanks to all of you smart people who knew the answer to my problem. It was
in fact the manual setting in the formula options. My next question is, how
did it get set to Manual?

Excel uses the calculation setting from the first workbook that is opened.