I can only attest to the use in macro's.
If your macro uses a full (unc) name \\server\directory..." then you'll have to change it.
If, OTOH, you're using a mapped drive "x:\directory..." and they *don't change the
mapping* you'll be ok.
Our shop had both and was recently upgraded (new servers, OS and Office) and this was our
experience.
Typically, whenever I write templates I use a standard "System" sheet that has the
Input/Output directories listed. My routines will then use the listed addresses for
processing. This made it easier to change, versus having the paths embedded in the code.

--
Regards;
Rob
------------------------------------------------------------------------
"Jebaneesa" wrote in message
...
The IT department at work has decided to upgrade our current server farm
which will result in the names of the servers changing. My question is how
will this affect macro's, links and Hyperlinks etc. in our current reports.
Will I have to relink all my Excel files or will they relink automatically
when they are opened from the new servers.

Any help greatly appreciated