Link source - Need change?
 

Hi,
I have two workbooks that are linked one to the other with formulas, the
source and the destination. I put the source workbook in a subfolder (Temp)
and the destination in the main folder on C:\.
In the destination workbook, I have formulas that look like this:
='C:\My Documents\Temp\[Links Origin.xls]Sheet1'!A6
If I copy the two files on a network folder, in a similar structure (the
source is in a Temp subfolder of the main folder where the Destination
workbook is), then do I need to do anything like update the links. I thought
so, but a simple test shows that the address in the formulas reflects the new
location of the source file. Is that normal?
Now, in the destination workbook, I have formulas that look like this:
='K:\SIGE\Temp\[Links Origin.xls]Sheet1'!A6
I thought I would need to program something to change the formulas, but it
seems that it is not the case.
Am I dreaming? How do links work? Are they relative?
Thanks.
--
Jac Tremblay