Hello all, thanks for any help you can provide.

I should mention I am using both Excel 2003 and 2007, as I have established a file that is being used by about 8-10 users within the office, about half still have 2003.

My problem is the following: I have an excel file that keeps a number of links to internally saved documents, as it is part of a way to keep track of files. For some reason, the links automatically update without my knowledge, switching from an absolute link (anchored to a shared drive) to a relative link (anchored to the person using the computer at the time).

Of course when switched to a relative link, all others that need to use the file lose access, which I am trying to avoid. Does anyone know why this might be happening? It seems to even happen on links that I have not selected, and no warning messages pop up.

Thanks to anyone that can help.

Best,

AD