Bizarre Linking Issue--network hardrive naming problem?

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Bizarre Linking Issue--network hardrive naming problem?

  1. #1
    New Member
    Join Date
    Apr 2004
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Bizarre Linking Issue--network hardrive naming problem?

     
    Hi there:

    I have a bizarre Excel linking issue at work which have been driving me crazy. The story goes like this:

    my department's electronic files are stored in a company-network hard drive named xxxxx01. Our portion of this hard drive is called Z. From a reference standpoint, Z:\ is equal to \\xxxxx01\department$\. Historically, some of our files have links to "Z:\" while others have links to "\\xxxxx01\department$\". Not surprisingly, for some unknown reasons, Excel cannot recognize the two refer to the same directory; as a result, linked cells are not automatically updated in most of my department's files.

    I am very curious to learn more about the cause of this issue as well as a quick and/or permanent way of fixing it. Many thanks!

  2. #2
    MrExcel MVP Zack Barresse's Avatar
    Join Date
    Dec 2003
    Location
    Oregon, USA
    Posts
    10,693
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    hi ramnpr, welcome to the board! not sure if i really know the exact answer to your problem, but here is some reference material for you which you may find use for...

    http://216.92.17.166/board2/viewtopi...+network+drive

    hth
    Regards,
    Zack Barresse
    My Book on Excel Tables
    My Blog @ ExcelTables.com
    (If you would like comments in any code, please say so.)

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com