It may depend on the location of the workbook.
I think it goes like this:

If it is opened via H: then its links will be via H: and held in effect
as relative links.
If it is opened via J: then its links will be via J: and held in effect
as relative links.
If it is opened via a different drive letter the links will be via
whichever drive it was opened from whtn it was last saved, and they
will be in effect absolute links.

If the workbook is currently accessed via H or J it would be
interesting to move it elsewhere and see if the problem goes away.
You could always leave a shortcut to it where it used to be!

Otherwise I guess you could write a macro to remake the links when they
have gone wrong.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup