Link to home
Start Free TrialLog in
Avatar of Nick Smith
Nick SmithFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Linked excel files - server migration

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?

Thanks
Avatar of Danny Child
Danny Child
Flag of United Kingdom of Great Britain and Northern Ireland image

Most Excel links are coded using drive letters

Here's an example from a random sheet of mine:
=VLOOKUP(A306,'T:\IT\[FileName.xls]Sheet1'!$A$2:$B$303,2,FALSE)
which is then shortened once that file is opened:
=VLOOKUP(A306,'[FileName.xls]Sheet1'!$A$2:$B$303,2,FALSE)

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.xls - but this is not natively how it builds paths, unless your users make a habit of connecting to resources via UNC in the first place.

More info here.
http://support.microsoft.com/kb/328440

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.
Avatar of Nick Smith

ASKER

Thanks DanCh99, I'll give it a go tomorrow and report back!
I had a similar exercise a number of years ago when changing the folder structure on a server, basically needed to move all folders and subfolders down a level.

I just moved (cut & paste) within Explorer and all the links moved fine. As DanCh99 says, the links may look like they are using Drive letters but I believe they use the relative UNC path behind the scenes; if one file is linked to another file that is three levels up, then a folder at that level and three levels down; each of those with the same folder names, the link should stay relative.

Thanks
Rob
so despite the server names being different, it's should really matter as Robocopy will move the files and folders over with  identical folder structure and permissions?
As Dan says, try with a sample first before doing the whole lot.
ASKER CERTIFIED SOLUTION
Avatar of Danny Child
Danny Child
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial