If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
UNC vs Mapped Drive Links
Does anyone know what determines whether a file is opened
with a UNC path or a mapped drive path? The problem we are having is related to a linked file. It was created and saved with the links to a source file using a mapped drive path. That is the the source file is P:\finance\linked.xls. The cells that are linked, save the link as P:\finance\2004\source.xls. However, when some people in the department, open the source file, it opens using the UNC path, \\Phfs1\public\finance\2004 \source.xls. If they add a new linked cell in linked.xls, that cell saves the link using the UNC path. As a result, the file ends up with links to linked.xls using both the UNC path and the mapped drive path. So I'm hoping to find a way to have everyone's machine default to opening the files the same way, either UNC or mapped drive. Thanks |
#2
|
|||
|
|||
UNC vs Mapped Drive Links
Darby wrote:
So I'm hoping to find a way to have everyone's machine default to opening the files the same way, either UNC or mapped drive. Understandable. I haven't met this myself. Do the UNC people have P: correctly mapped with appropriate permissions? If a P: person opens it on a UNC person's computer do they get P: behaviour or UNC behaviour (ie is it user-related or machine related)? Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
|
|||
|
|||
UNC vs Mapped Drive Links
Bill,
Thanks for your leading questions. As a result of trying to determine the answers, we may have solved this conundrum. It seems the UNC folks, were accessing the file through a favorites shortcut that was using the UNC path. The P: person (me actually) was simply opening through the File/open menu route and following the mapped drive path to get to the file. Hopefully, we can now agree on one path to the same end. Again, thanks for taking the time to help. Darby -----Original Message----- Darby wrote: So I'm hoping to find a way to have everyone's machine default to opening the files the same way, either UNC or mapped drive. Understandable. I haven't met this myself. Do the UNC people have P: correctly mapped with appropriate permissions? If a P: person opens it on a UNC person's computer do they get P: behaviour or UNC behaviour (ie is it user-related or machine related)? Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Hyperlink to a Mapped Drive and Not a Full UNC path | Bomber | General Discussion | 1 | June 21st, 2004 12:29 PM |
Please help me to re-install Office on my D drive to save space on my C drive: | Lewis | New Users | 3 | June 9th, 2004 01:26 AM |
Please help me to re-install Office on my D drive to save space on my C drive: | Lewis | General Discussions | 2 | May 25th, 2004 11:50 AM |
Excel 2000 converts UNC links to relative - need to preserve UNC links! | Jeff Adams | Links and Linking | 3 | April 15th, 2004 05:46 PM |
Links Mapped Drive Letter Changed | Ana | Links and Linking | 5 | February 18th, 2004 05:01 PM |