I'm looking at moving a large set of excel files from one machine to another. I need to move them in a way that ensure all the linkings continue to operate. The structure is not changing, i.e "foldera\sunfolderb" etc will continue to be "foldera\subfolderb" albeit on a different server.
Upon testing i've found that the links seem to change but not the complete path - e.g.
(" " for illustration of structure only)
But the links only partially update; i.e
old path = servera\"foldera\subfoldera\filea"
newpath = serverb\"foldera\subfoldera\filea"
i.e the server changes, but not the remainder of the path
In some cases the links don't alter at all.
Obviously it is essential that the links continue to operate for the spreadsheets to work as intended, and I need to ensure that all links carry over.
All standard hardware etc, fully patched etc, I thinks this is not so much as a fault, but a knowledge thing so I havn't put many details of environment etc, but please advise should you believe they are of concern.
As always, all help is much appreciated.