Globally change relative-addressed hyperlinks to absolute-addr

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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