How do I make a global change of Hyperlink addresses?

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

I have a large group of hyperlinks that have changed the base part of their
address. Probably when the spreadsheet quit and I had to recover the file.

Instead of pointing to another drive, all of them point at the c drive. Can
I do a global edit somewhere?
 
You can do this with 'find and replace'...

If you have them through formulae then first change to display formulae (by
CTRL-`) and then use 'find and replace'...
 

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

How Can I Globally Change Hyperlink Addresses? 1
How Can I Globally change Address of Hyperlinks? 1
Hyperlinks changed by Excel again! 5
Global Hyperlink Changes 4
How do I remove ALL hyperlinks from a large worksheet? 1
Hyperlink problem. 1
How would I change all hyperlinks at once? 1
multiple Hyperlink address change 2

Back
Top