Excel Hyperlinks
 

How can you amend a number of hyperlinks where the location has changed but
the actual page name hasn't. E.g. file:\\fred\page01 all the links are now on
John, file:\\john\page01, 02, 03 etc.
It seems from what I see that there is only a one at a time method.
Does it require a macro?

Excel Hyperlinks
 

Have you tried using Edit/Replace (CTRL-H)? Highlight all the cells
with hyperlinks, then CTRL-H, and:

Find what: \fred\
Replace with: \john\
then click Replace All.

Hope this helps.

Pete

On Aug 13, 4:20*pm, BoobyD wrote:
How can you amend a number of hyperlinks where the location has changed but
the actual page name hasn't. E.g. file:\\fred\page01 all the links are now on
John, file:\\john\page01, 02, 03 etc.
It seems from what I see that there is only a one at a time method.
Does it require a macro?