Globally change relative-addressed hyperlinks to absolute-addr

H

Herman H

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.
 
R

Roland

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.
 
Top