I have a named range in a source spreadsheet which is linked to other
spreadsheets. I edited one of the values in the range (I changed C27 to C20)
and I use this as an example to show references in the column - =C23, =C24,
=C25, =C26, =C20, =C28, =C29 etc.

However, when I run the macro to update the linked spreadsheet, the
reference has reverted back to C27. How can I stop the link from changing
back?

Thanks in advance.