changing hyperlinks

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!

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

Ehren wrote:
>
> 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