Excel Hyperlinks

[BoobyD]

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?

 

[Pete_UK]

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