I have a sheet called "2015".
In row "A" are listed the month of the year ( A1 Jan; A2 Feb ...)
In row "B" are numbers that have to be summarized in the end ( B13 )
In row "C" there are checkboxes that are bound to the field they are in ( C1; C2;..)
The sum in "B" depends on the checkboxes, whether they ar "on" or "off". (sumif ...)
If I copy the sheet and rename it to "2016" the checkboxes are still bound to "2015" because in the "linked cell" there is not only "C1"; "C2"; ... to be found, but "'2015'.C1";"'2016'.C1"; ... and so on.
That is quite uncomfortable because I have to correct every single checkbox.
Thank you for considering to change that behaviour.
In the copied cells the reference is:
Thank you for submitting the bug. The bug has previously been reported, so this bug will be added as a duplicate of it. You will automatically be CCed to updates made to the other bug.
*** This bug has been marked as a duplicate of bug 47662 ***