Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linked cells and Mapped Network Drives
I have a worksheet that is linked to a second sheet on a different network
drive. Is there any way that the link can store the drive name and not my assigned drive letter? If others have the drive mapped to a different letter the link does not work. Thank you, Jim |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linked cells and Mapped Network Drives
Let's say you have drive //drive1/file01/file02 mapped to Y:
Just do a global change of Y: to //drive1/file01/file02. I think that should work. "James McDowell" wrote: I have a worksheet that is linked to a second sheet on a different network drive. Is there any way that the link can store the drive name and not my assigned drive letter? If others have the drive mapped to a different letter the link does not work. Thank you, Jim |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linked cells and Mapped Network Drives
Is thi something I can do to eliminate the problem or is this an action
another user would have to take once they opened the file? "Barb Reinhardt" wrote: Let's say you have drive //drive1/file01/file02 mapped to Y: Just do a global change of Y: to //drive1/file01/file02. I think that should work. "James McDowell" wrote: I have a worksheet that is linked to a second sheet on a different network drive. Is there any way that the link can store the drive name and not my assigned drive letter? If others have the drive mapped to a different letter the link does not work. Thank you, Jim |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linked cells and Mapped Network Drives
This is something that you can do before you send it to other users. The
drive name is probably more like \\drive1\file01\file02 (note change in direction of slashes). I've done this before so I know it works. ... Now that I think of it, you'll probably have to have another helper column with the link. In the helper column use the HYPERLINK function. Let's say you have A1: C:\Documents and Settings B1: = hyperlink(A1) "James McDowell" wrote: Is thi something I can do to eliminate the problem or is this an action another user would have to take once they opened the file? "Barb Reinhardt" wrote: Let's say you have drive //drive1/file01/file02 mapped to Y: Just do a global change of Y: to //drive1/file01/file02. I think that should work. "James McDowell" wrote: I have a worksheet that is linked to a second sheet on a different network drive. Is there any way that the link can store the drive name and not my assigned drive letter? If others have the drive mapped to a different letter the link does not work. Thank you, Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|