I currently have multiple documents on different file
servers linked together via hyperlinks using Excel 97. In
the future (a year) the server names will be changing due
to infrastructure upgrades and as the hyperlinks use the
full path of a document these will have to be edited.

The problem is that there are hundreds of links within
and I wondered whether there is a faster way than editing
every single link to accomodate the new server name?