At my company, we tend to use a lot of linked worksheets. All of our stuff is on a mapped network drive (K:\). When I copy a section of data from one sheet (say its K:\Pub\Data\BookA.xls) and paste special links to another sheet, the links will say 'K:\Pub\Data\[BookA.xls] Sheet1'!A1.

That's exactly what I want the links to look like. However, after some time the links change to look like this instead:
'\\10.100.10.2\Pub\Data\[BookA.xls] Sheet1'!A1

Sometimes it even changes to include the name of the mapped drive (say the name of K is MappedDrive):
'\\10.100.10.2\MappedDrive\Pub\Data\[BookA.xls] Sheet1'!A1

What's annoying about this is that if I update data in BookA, cell A2 and I want to reflect that in the new linked sheet, I have to click into the cell and edit the link to look like the K:\ version and then drag it down.

We used to work at another firm and did things the exact same way and never had this problem before. I'm not sure what causes the links to change format since some of them stay in the K:\ format forever and others switch to the \\10.100.... format randomly.

Anyone have any ideas?

Thanks