Copy Formula Problem
 

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.
--
MC

Copy Formula Problem
 

You probably just need to recalculate.
Press F9.

Regards,
Paul

--

"Mike C" wrote in message
...
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.
--
MC

Copy Formula Problem
 

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.
--
MC


"PCLIVE" wrote:

You probably just need to recalculate.
Press F9.

Regards,
Paul

--

"Mike C" wrote in message
...
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.
--
MC