Broken Hyperlinks

[Michelle]

I am using a workbook on an internal network with a large shared drive,
though each user also has their private C drives as well. The workbook is not
shared, so only 1 user can make changes at any time. There are 1000 or more
hyperlinks in this workbook and recently every one of these hyperlinks
changed from the shared drive to one user's C drive.

Why would this happen and is there a setting that can be changed to correct
it in excel?

Otherwise, how can I fix all the hyperlinks in this workbook without
addressing each one individually?

 

[Michelle]

For both the Flexfind tool and the search and replace functions, it won't
pull up the hyperlink address as this is not the text displayed. I can
extract the text and use find and replace on that, but I don't see how to
move the amended addresses back to the hyperlinks with the correct text
displayed. Is there a way that I can do that?

 

[Michelle]

I figured it out- use the =HYPERLINK(actual address, friendly address)
formula with references to the extracted text and the broken links.

Still don't know how that ever could have happened though.

 

[Alan124]

I am using a workbook on an internal network with a large shared drive,
though each user also has their private C drives as well. The workbook is not
shared, so only 1 user can make changes at any time. There are 1000 or more
hyperlinks in this workbook and recently every one of these hyperlinks
changed from the shared drive to one user's C drive.

Why would this happen and is there a setting that can be changed to correct
it in excel?

Otherwise, how can I fix all the hyperlinks in this workbook without
addressing each one individually?

Hi,

You may try Advanced Excel Repair at http://www.datanumen.com/aer/
This tool is rather useful in salvaging damaged Excel xls files.

Hope this will help.

Alan