R
richard bishop
Hi all
This is a bit complex to explain, but I'll do my best.
I have a spreadsheet (Daily.xls) that links to another
file (orders.xls). Daily.xls is sent to me by e-mail
every day, the link reading "C:\Documents &
Settings\Smith\data\orders.xls". I open the file without
updating the links, and the data is correct. My name is
not Smith, so I have no C:\...\Smith etc. on my PC.
However if I open another file for the previous day, or
any other day (still called Daily .xls, but opened as a
number by Notes, so there is no name conflict), which
still contains a link to C:\...\Smith\...orders.xls, the
numbers on my first file are updated to the numbers on
the second file. I have not selected Update Links, the
file does not even exist on my PC, and yet because two
open files have the same formula links, the two files
become identical.
I could try a work- around by pasting values, but I am
more interested in finding out how Excel can possibly do
this.
This is a bit complex to explain, but I'll do my best.
I have a spreadsheet (Daily.xls) that links to another
file (orders.xls). Daily.xls is sent to me by e-mail
every day, the link reading "C:\Documents &
Settings\Smith\data\orders.xls". I open the file without
updating the links, and the data is correct. My name is
not Smith, so I have no C:\...\Smith etc. on my PC.
However if I open another file for the previous day, or
any other day (still called Daily .xls, but opened as a
number by Notes, so there is no name conflict), which
still contains a link to C:\...\Smith\...orders.xls, the
numbers on my first file are updated to the numbers on
the second file. I have not selected Update Links, the
file does not even exist on my PC, and yet because two
open files have the same formula links, the two files
become identical.
I could try a work- around by pasting values, but I am
more interested in finding out how Excel can possibly do
this.