![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
New Member
Join Date: Apr 2002
Posts: 4
|
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 |
|
Board Regular
Join Date: Feb 2002
Location: Stockton, California
Posts: 281
|
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 |
|
|
|
|
|
#3 |
|
New Member
Join Date: Apr 2002
Posts: 4
|
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!! |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|