Server name changes

J

Jebaneesa

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
 
F

Fredrik Wahlgren

Jebaneesa said:
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
Click to expand...

When you use hyperlinks, you use an URL or a path, right? If an URL is
used, the links should work as before. If you use a path, make sure the IT
dept doesn't rename the drives. My experience is that IT staff may do so.
What used to be the K drive is now X or similar.

/Fredrik
 
J

Jebaneesa

Thanks Fredrik,

I have been assured that the drives wont change only the first part of the
server address. Do you think my links and macros etc will still work?

Jebaneesa
 
F

Fredrik Wahlgren

Jebaneesa said:
Thanks Fredrik,

I have been assured that the drives wont change only the first part of the
server address. Do you think my links and macros etc will still work?

Jebaneesa
Click to expand...

I haven't used hyperlinks but I'm pretty sure that things will work as
before unless you have something where the actual server name is used. I
think that's highly unlikely. I have never seen such a link.

/Fredrik
 
R

RWN

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.
 
D

Dave Peterson

When you created your links/hyperlinks/macros, did you refer to those sharenames
by the mapped drive:

Like: N:\
or did you use the UNC style:
\\myserver\myshare\myfolder1\myfolder2\myfile.xls

If you used the mapped drive letter, you may not have any trouble at all.

If you used the UNC and your links point with in the same folder, you may get
lucky and not have anything to do (for links, anyway).

For links, you can use Edit|Links and point at the new location (for the ones
that need to be changed).

Bill Manville's FindLink addin may help you find the hard to find links:
http://www.oaltd.co.uk/MVP/Default.htm

For hyperlinks (Insert|Hyperlink), David McRitchie has a macro approach that may
help you fix stuff:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm
look for:
Fix Hyperlinks (#FixHyperlinks)

For macros, you'll have to fix those yourself.

====
But I wouldn't really guess if all would work ok. The only way you'll really
know is by trying them.

(Pain in the ..., huh?)
 
Top