Globally change relative-addressed hyperlinks to absolute-addr
 

Excel spreadsheet has links to several files. Can I globally change
relative-addressed links to absolute-addressed links? If not, what's easiest
way to make the change. Files are not all in same folder.

Globally change relative-addressed hyperlinks to absolute-addr
 

Use with care, but try the functionality of find and replace available from
Edit Find.

Find the constant portion of your hyperlink text, and replace it with the
new constant portion for the absolute address.

"Herman H" wrote:

Excel spreadsheet has links to several files. Can I globally change
relative-addressed links to absolute-addressed links? If not, what's easiest
way to make the change. Files are not all in same folder.