I'm in the process of migrating data from a Win 2003 server to a new server.
I have already migrated a lot of the shares using Robocopy but leaving the mother of all shares until last (that I am rapidly approaching!) due to it's size and complexity.
The share contains lots of complex excel sheets which usually wouldn't be a problem with Robocopy but some of them have active links to other spreadsheets (within the same share)
My question is, when I use Robocopy to migrate this volume. When it's live on the new server (with a different server name) will the links in excel need to be re-established as they are looking at a file path that contains the old server name?
I'd like to establish this prior to migration as if the links will be lost then I need to notify the teams! Unless there is a way around it or a tool I could use?
Here's an example from a random sheet of mine:
which is then shortened once that file is opened:
So, if your folder structure is the same, and your drive mappings are the same, you should be fine.
Excel CAN work with UNC paths - \\Server\Share\Filename.xl
More info here.
I'd suggest asking your most knowledgeable and old-time Excel users to suggest a typically large and evil set of sheets, and to try a sample robocopy of that branch of your folder tree only.