Unstable links

[aitkena]

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?

[robfo0]

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

[aitkena]

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!!