Copy Formula Problem

M

Mike C

This is weird. When I copy a formula and paste it, the new cell displays the
old cell's data, even though the formula has been changed to reflect the
relative cells.

Example

Row 1: 1 + 2 = 3 (formula is A1+B1)
Row 2: 2+3 = 3 (formula is A2 + B2)

Why does it still display 3 in cell C2? If I type in the formula it works.
 
M

Mike C

Thank you. I was going crazy! I also found that I need to change the option
in tools | options... Calculation tab to Automatic under Calculation.

Thanks again.
 
Top