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

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!
--
ace

Copy formula down - cell references change - result is same foral
 

ace wrote:
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.

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

Make sure calculation is set to automatic.

Excel 2007:

Formulas tabCalculationCalculation OptionsAutomatic

All other versions of Excel:

ToolsOptionsCalculation tabAutomaticOK

--
Biff
Microsoft Excel MVP


"ace" wrote in message
...
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!
--
ace

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

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

"ace" wrote:

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!
--
ace

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

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" wrote:

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!
--
ace

Copy formula down - cell references change - result is same fo
 

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? :-)
--
ace


"Mike H" wrote:

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

"ace" wrote:

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!
--
ace

Copy formula down - cell references change - result is same fo
 

ace wrote:
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.