Hyperlinks in Excel Woprksheet

[Derker04]

I have inherited a spreadsheet containing 1500 hyperlinks. It is an index of
docs with 1 link per pdf file.

Some of the hyperlinks were incorrect and I amended them 6 weeks ago.
There are now some incorrect hyperlinks again and where 3 are incorrect in
adjoining cells in same column if I change the first one the other 2
automatically correct themselves.

Is this something to do with how the spreadsheet has been setup?
How can I prevent the unexplainable changes to hyperlinks happening in future?

 

[Gary''s Student]

You did not say if the hyperlinks were place using the Insert > Hyperlink
menu command or the =HYPERLINK() worksheet function.

The =HYPERLINK() function is much more stable.

 

[Derker04]

I think the links were created using Insert > hyperlink.

When you state unstable - is this a known issue with the hyperlink function
in excel?

 

[Gary''s Student]

I'ts the function that is stable.