A client has an excel spreadsheet they've got hyperlinks on. They use the
links to link to JPG pictures on a file server on their network. There's
about 650 or so of these links, all were put in manually as this file grew
(parts list).
They have since moved their data to a new server, and thus the path needs to
change (\\server1\blahblah to \\server2\blahblah).
Is there any easy way to do a find and replace for *part* of a hyperlink? I
would assume it's an all or nothing proposition?
I found the file / properties / summary / hyperbase link option, but I don't
see how that would help since the wrong path is already in all the links?
Thanks for any suggestions
--
John
Bookmarks