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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing hyperlink addresses (global)? 1
Conditional formatting on a dynamic range - workaround 1
change hyperlinks from relative to absolute 1
Hyperlinks changed by Excel again! 5
Help with converting a block of cells with Absolute and mixed references to relative references 3
How do I stop "global" hyperlinks changing to "local" links? 2
changing from relative to absolute cell reference in multiple form 1
Word changing hyperlinks from relative to absolute 7

Back
Top