Metallo wrote:
Is anybody able to reply?
Am I in the right forum or maybe should I post this in Programming?


This is the appropriate section.

I would like to be able to answer the question but it is not a
behaviour I have experienced so I don't know the answer for certain.

In my experience, if the source workbooks and the destination workbook
are in the same folder then no adjustment should be needed to links if
all the workbooks are moved to a different folder (since the links are
effectively held as relative links).

However, if you sometimes access a file via a drive letter and
sometimes via a UNC filename (\\home share\...) then Excel can
sometimes fail to recognise that the two files are in the same
directory and then has to use the full path to the destination file.

If the full path is too long then I can imagine there are problems.
Can you shorten the path at all by using shorter folder names?

Which version of Excel?
What is the full path of the file that fails to relink?

You could try moving all the files to your local machine (with a short
path), relink the files there, then move them back using Windows
Explorer, not Excel File / Save As, to the network folder. That should
make the links behave as relative links I think.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup