Hyperlink conversion

[narrowgate88]

I have just been told that one of our servers is being replaced this weekend. I have thousands of hyperlinks in excel docs that reference this server. Other than manually reestablishing the links one by one to the new server, is there a way to do some kind of global change to replace the old server name with the new server name?

These are not hyperlink formulas, but rather Insert>>Hyperlink.

Or, is there a way to convert these hyperlinks to hyperlink formulas that would omit reference to the server and thus not be broken during the conversion?

Grasping at straws because I cannot envision having to relink these one by one.

[Palmetto]

Maybe this link will help: Change Multiple Hyperlink Paths

[narrowgate88]

I couldn't get that to work quite right, but I found this macro. I adjusted it to see if I could replace part of the hyperlink and it did work for replacing "Crowe".

Please Login or Register  to view this content.

Now my problem is this. When I hover over the hyperlink I see this address:

Please Login or Register  to view this content.

But, if I go in to edit the hyperlink, I get this address:

Please Login or Register  to view this content.

I need the chinas01 changed, not Crowe, but that doesn't show in the second address.

[narrowgate88]

This code fixed my problem.

Please Login or Register  to view this content.