In Excel, using worksheets that are on the server and linked together, when
is file is open, any file linking to it recognizes that it is open and drops
the server name from the linked cell and refers just to the folder the file
is located in.

My problem is that for certain files, even though open, are not recognized
as being open by a linked file, thus causing it to go searching for that file
and taking forever to post changes to the worksheet, also if you open an
excel speadsheet using Windows Explorer the links are one way and if you open
Excel first and then open the same worksheet the links are different.