Workbook with multiple worksheets set up, worksheets having links to other
worksheets within that workbook.

A worksheet (with internal links) copied or moved to another workbook and
the links amended to the new (local) workbook, Saved and closed.

On reopening the new workbook, get message advising of external links and
asking if the data is to be updated, although there are now no longer any
external links for that worksheet. Have searched through for any remains of
external links but nothing found, neither are there any modules (with or
without external links) attached to the workbook.

Have tried copying the worksheet as a whole, and also copying the data to a
new worksheet then deleting the original worksheet, but still get the
“update/links” message on opening when that worksheet or a copy of its data
still exists in that file. Can copy the format only to a new worksheet – this
does not seem to carry the "links" with it. If the worksheet is deleted (and
no copy of its data is left in another worksheet) and the workbook Saved,
then there is no "links" message upon reopening.

Have tried both copying AND moving the worksheet from the original workbook
– same result.

How can a worksheet – with links to worksheets in the original workbook – be
moved/copied to another workbook with the links then being reset to the local
workbook, without getting this apparent “carry-over” back to the original
file?

Many thanks.