How Can I Globally change Address of Hyperlinks?
 

I seem to know just enough about Excel to be dangerous, and therein
lies my question.

I have a spreadsheet (1 sheet) that has some 600 (and climbing) rows,
one column of each having a hyperlink to a file on an external drive.
Eventually, all the linked files will be moved to another disk and the
links changed to that new drive's location.

Is there a way to globally change the links to the other disk when the
project is completed. I have stopped adding links until I discover a
way, for I really don't want to do the changes manually one at a time!

Thanks for any advice.

Cheers--

Terry--WB4FXD
Edenton, NC

How Can I Globally change Address of Hyperlinks?
 

Two ways:
If you are using the HYPERLINK function, it's as simple as doing a Find &
replace.

If you used a base address to setup embedded hyperlinks (see XL help file
article "Set the base address for the hyperlinks in a workbook") you can
simply change this from the File - Properties, summary dialogue.

If you chose option 3, where you inserting a hyperlink into each cell using
a full file extension, you will probably have to setup a macro that loops
through your cells, takes current hyperlink address, and changes it to new
desired address.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Terry" wrote:


I seem to know just enough about Excel to be dangerous, and therein
lies my question.

I have a spreadsheet (1 sheet) that has some 600 (and climbing) rows,
one column of each having a hyperlink to a file on an external drive.
Eventually, all the linked files will be moved to another disk and the
links changed to that new drive's location.

Is there a way to globally change the links to the other disk when the
project is completed. I have stopped adding links until I discover a
way, for I really don't want to do the changes manually one at a time!

Thanks for any advice.

Cheers--

Terry--WB4FXD
Edenton, NC