Hyperlink Query

Hi,

We have this spread*** which resides on a network share (M drive),
within this spread*** there are numerous rows of data, each one
refers to the M drive, via a hyper-link this then opens another
spread*** on the M drive within a seperate folder. The problem I
have is, somehow all of the link locations have changed to C:
\documents and settings\<user>\application data\microsoft\excel
\<folder name>\<folder number> (20,000 of them !)
I suspect that someone has copied the file of the network, worked on
it locally and saved it to there C:, then copied the file back up. Can
someone please shed any light on this as to either, change all the
links back to the correct location or suggest how this may have
happend so that I can stop it happening again.

As always, your help is much appricated.

John.

.