Autofill issue...

[Guest]

When I use the autofill option by dragging down the roght bottom corner of a
cell, excel is carrying down the formula correctly but it is using the result
from the cell above... The formula looks correct (excel is sliding the rows
down) but the answer to the formula is the same. Example...

Column 1 Column 2 Column 3

1 2 3 (=sum(A1:B1)
2 3 3 (=sum(A2:B2)
3 4 3 (=sum(A3:B3)

How do I correct this? I assume it is in the Autofill options, but I can't
find it. Any help is greatly appreciated.

Thanks,
JRG

 

[Jason Morin]

Make sure the wb is *not* set to Manual Calculation
(check under Tools > Options).

HTH
Jason
Atlanta, GA

 

[nc0229]

I'm not certain if it help Jonathan but it solved my problem. Thanks