D
Dot
I have 2 files P:\finance\2003\source.xls and
P:\finance\2004\linked.xls. The formulas in the linked
document read ('\\Phfs1\Public\Finance\2003\source.xls).
The links only update if I open source.xls though the Edit
Links Open Source menu options. If I open source.xls
directly, linked.xls doesn't recognize it as the correct
source.
To make matters worse, if I add a new linked cell from the
unrecognized source.xls, the formula in linked.xls will
read P:\finance\2003\source.xls, leaving 2 differant names
for the same file in the linked file listing, making
difficult to get linked.xls updated with current data.
Note that both files are very large - source.xls 18MB,
linked.xls 4MB
Any body have any ideas here?
P:\finance\2004\linked.xls. The formulas in the linked
document read ('\\Phfs1\Public\Finance\2003\source.xls).
The links only update if I open source.xls though the Edit
Links Open Source menu options. If I open source.xls
directly, linked.xls doesn't recognize it as the correct
source.
To make matters worse, if I add a new linked cell from the
unrecognized source.xls, the formula in linked.xls will
read P:\finance\2003\source.xls, leaving 2 differant names
for the same file in the linked file listing, making
difficult to get linked.xls updated with current data.
Note that both files are very large - source.xls 18MB,
linked.xls 4MB
Any body have any ideas here?