How do I make a global change of Hyperlink addresses?

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?
 
S

Sheeloo

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
change part of hyperlink formula 3
Global Hyperlink Changes 4
Email addresses won't hyperlink in Excel 1
multiple Hyperlink address change 2
hyperlink error 2
Change hyperlink name to url 1
Hyperlinks changed by Excel again! 5

Top