I have inherited some spreadsheets and there are links in -
no problem with that in itself.

However, as a general principle, what happens when you
create further versions of the file?

It gets updated from time to time, and previous users have
apparently created the "next" version by File Save as. It
looks to me as though the links in the *related* files
change to point to the newly-saved file, and although I
can understand the logic it seems to me that you should
really be offered the option of making the change.

As far as I can tell, making a copy in any other way such
as via Explorer leaves the links pointing to the original
file.

I know I can change the links by Edit Links, but can
anyone confirm that what I have outlined is correct, and
if they know of any way of preventing it happening in the
first place? A number of users have access to these files,
from different locations, and not all of them will realise
what is happening behind the scenes, so there is a danger
they will blithely go on assuming a link is doing one
thing when in reality it is doing something completely
different!

Thanks for any thoughts/comments etc