Hyperlink in Excel spreadsheet

[Theresa]

Hello, I have a about 1000 cells in a worksheet that are hyperlinked. The
hyperlink path changed on all to a file path that is not recognized. How do
I change the hyperlink to the correct file path without going into to each
cell and editing the path? The path is the same for all, just a different
file name.

 

[Eduardo]

Hi,
Click the Microsoft Office Button , click Prepare, and then click Properties.
In the Document Information Panel, click Document Properties, and then click
Advanced Properties.
Click the Summary tab.
In the Hyperlink base box, type the path that you want to use.

 

[Theresa]

Thanks, I tried that, but it doesn't change the hyperlink path.

 

[Dave Peterson]

Changing this hyperlink base may stop the links from being changed again,
though.

Saved from a previous post:

If you used Insert|hyperlink (xl2003 menus), you'll have more work to do. But
the good news is David McRitchie has done most of it for you:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm
look for:
Fix Hyperlinks (#FixHyperlinks)

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

 

[Theresa]

I got the macro to work but it duplicates the new path in the hyperlink. Any
ideas?

 

[Dave Peterson]

Share the before version of the hyperlink.
Share the code you used.
Share the after version of the hyperlink.

 

[Dave Peterson]

ps. Share the version of excel you're using, too.

 

[Theresa]

I tried it again and changed my destination path and it worked. Thanks for
your help.