View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roland
 
Posts: n/a
Default 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.