EXCEL Hyperlinks

[matthew_h]

I have an EXCEL document that has hundreds of hyperlinks to different
folders within a single shared folder on a file server.

The Shared folder has been moved to another file server and thus the
hyperlinks are now incorrect.

Only the server name has changed in the hyperlink paths.
Is there a way to change the paths of all the hyperlinks without opening and
modifying each hyperlink?

For example, I need to change the hyperlinks from
\\old_file_server\shared_folder\job_folders\ TO
\\new_file_server\shared_folder\job_folders\

thanks!

 

[Bob Buckland ?:-\)]

Hi Matthew,

You may want to use the link below to also ask in the MS Office Excel discussion group and when posting there please include the
version of Excel you're working with.

============

I have an EXCEL document that has hundreds of hyperlinks to different
folders within a single shared folder on a file server.

The Shared folder has been moved to another file server and thus the
hyperlinks are now incorrect.

Only the server name has changed in the hyperlink paths.
Is there a way to change the paths of all the hyperlinks without opening and
modifying each hyperlink?

For example, I need to change the hyperlinks from
\\old_file_server\shared_folder\job_folders\ TO
\\new_file_server\shared_folder\job_folders\

thanks! >>
--
Please let us know if this has helped,

Bob Buckland ?
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com