Copied and Pasted a sheet but some cell references have referenced the previous version of the sheet?

Question

Level 1

51 points

Copied and Pasted a sheet but some cell references have referenced the previous version of the sheet?

I copy and paste sheets and rename them v1, v2 , v3 all the time, but I just noticed my versions 6 of a calculator is referencing version 5. In fact the name of the cell defence has changed in that when I made version 6 the cell reference added "v5" in the code?

I am trying to work out why the cell referencing naming convention has changed or how I might have accidentally caused this? As mentioned I've not noticed it before?

Cheers!

MacBook Pro 15″

Posted on Oct 8, 2023 04:09 PM

Reply

Answer 1

Top-ranking reply

Recycleur

Level 4

1,627 points

Oct 9, 2023 05:55 AM in response to Bardonicloud

My guess is that after duplicating v5 to make v6 you copied some formulas from v5 to v6, so they still refer to the same cells in v5 even if they are on v6.

I simulated that same thing in the example below. See how the formula in Sheet2::Table 2 went back to refer to Sheet 1::Table 1 after I copied the formula only.

Reply

Answer 2

Recycleur

Level 4

1,627 points

Oct 8, 2023 04:30 PM in response to Bardonicloud

If the formulas are looking at source data in tables on the same sheet and you copy the sheet, the duplicate sheet should still work with its own version of the tables.

But, if sheet A had references to sheet B and you duplicate sheet B to become sheet C, the formulas on sheet A will continue to look for source data on sheet B.

Reply