Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Unstable links

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

    Default

    I've recently come across the following problem:

    - I created a brand new spreadsheet (New.xls) that links to one cell in a spreadsheet in directory A called name.xls
    - I have another spreadsheet in directory B, also called name.xls
    - when I open directory B's name.xls (obviously with directory A's name.xls closed), the numbers in New.xls change to numbers that I can't trace back anywhere

    Directory A's name.xls was created 6 months prior to Directory B's name.xls, and has not been changed since it was created, hence it can't possibly be linked to Directory B's name.xls. However, Directory B's name.xls does link to Directory A's name.xls

    Do you know what might cause this problem, and how I could go about fixing it?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Stockton, California
    Posts
    281
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    aitkena,

    My first instinct would say it has something to do with the cell reference. If you look at the reference (at least when i tried it) it just links to the workbook (not the path). It seems you need a way to keep a specific path in the link. When i tried putting a path in, excel took it out automatically. either that or name the file something different im sure someone knows how to handle this path problem

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for replying so quickly!

    The reference does have directory A's full path name, which is why the problem has really got me stumped! Also, after I open directory B's name.xls and the link changes to an unknown number, I can then choose to update links (directory A's name.xls is the only file in the "links" menu) and the number changes back to the right one!!

Some videos you may like

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
  •