Copy Formula Problem

G

Guest

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Excel VBA 1
Write formula for simple copy and paste to another cell 1
Copy formula down - cell references change - result is same for al 6
Copy Data from One Spreadsheet to Another ?????? 5
Sum automatically every cell in multiple rows 1
Display formula with values referenced 3
Opposite direction 9

Top