Share via

Relative Reference not working

Anonymous
2010-09-13T18:40:00+00:00

When I copy a formula from one cell to the other, the displayed value in the destination cell is the same as the source cell.  However, if you display the formula or highlight the cell,  the formula shown is the new formula based on cell position (eg =A1*B1 copied one cell below is =A2*B2.  No matter how I copy and paste,  the displayed value is the source cell value instead of the formula value.  THis happens in older stored spreadsheets as well as freshly created ones.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2010-09-13T18:48:15+00:00

Hi,

Try this

Formulas tab - calculation group - calculations options - select automatic

In case your wondering how it got like that, Excel is helpful and remembers the setting from the first workbook opened in a session so if that was manual calculation than it will remain so.

If this post answers your question, please mark it as the Answer.

Mike H

Was this answer helpful?

1 person found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-01-27T21:48:28+00:00

    Mine relative cell reference acts like an absolute reference regardless of dragging it in a row or in a column. My workbook calculations are set to automatic. What the reason for this?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2010-09-14T03:36:00+00:00

    That was it!  Thank you so much - this was driving me crazy!!

    Was this answer helpful?

    0 comments
  3. Anonymous
    2010-09-13T18:46:32+00:00

    Hi,

    is A2 the cell to refer in that case use

    =$A$2*B2

    when formula is copied down will display

    =$A$2*C2

    Was this answer helpful?

    0 comments