Hyperlink in Excel spreadsheet

  • Thread starter Thread starter Theresa
  • Start date Start date
T

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.
 
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.
 
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.)
 
Share the before version of the hyperlink.
Share the code you used.
Share the after version of the hyperlink.
 
Back
Top