changing hyperlinks

[Guest]

Hello-

I was looking to see if there was a way to mass change hyperlinks in excel.
We rescently had a server change and a bunch of hyperlinks (rather a TON)
were linked to that server name, and now none of them work. Its a lot of
work to change each one individually and wondered if there was a way to do a
find and replace of sorts to change all of the hyperlinks at once.

Any suggestions?

Thanks!

 

[Dave Peterson]

Take a look at David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
look for:
Fix Hyperlinks (#FixHyperlinks)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm