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

"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

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

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

"Fredrik Wahlgren" wrote:


"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

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

"Jebaneesa" wrote in message
...
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


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

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

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?)





Jebaneesa wrote:

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

--

Dave Peterson