Link to full path not short path

[axg275]

Hello All,

I have a question. When i try to link the cell from one workbook to another, when I close linked workbook the link is short ex: G:\...... What I want it to do is give me full path such as \\gou1\cou\... ect. G drive is a mapped drive in windows for me but I dont want it to show up like that in my workbooks since other people that will use this workbook dont have the same letter linked to that drive.

I dont know if there is a way to fix that or not. If you know of a solution please let me know

Your help is much appreciated!

 

[GlennUK]

Does this help:

http://support.microsoft.com/kb/328440

?

 

[axg275]

yeah that answers the question. Do you know if there is a way to put full path even though you opened the file through relative path?