hi Ket,

a bit of VBA will do the trick.

Code:
--------------------

For Each h in Worksheets(1).Hyperlinks
Replace( Expression := h.address, _
Find := "old_server_name", _
Replace := "new_server_name" )
Next

--------------------


HTH

Art


--
HiArt
------------------------------------------------------------------------
HiArt's Profile: http://www.excelforum.com/member.php...o&userid=19953
View this thread: http://www.excelforum.com/showthread...hreadid=378039