Editing Text and file location for Hyperlinks

[forest8]

Hi

I have a document that uses hyperlinks. At the moment, I am inserting
indivual hyperlinks which inserts the file location for each sheet and the
display text. This file is over 200 pages and I need to learn of an easy way
to edit each hyperlink easily.

Is this possible?

Thanks

 

[Gary''s Student]

Let's say you are creating the hyperlinks using:

Insert > Hyperlink

and editting them the same way.

Instead, put the address in column A and the text in column B, then in C1
enter:

=HYPERLINK(A1,B1) and copy down. This will produce a nice "click-able"
table of hyperlinks. You can change the links anytime without having to use
the DialogBox.