Links between Workbooks
 

I have linked a cell in one workbook to a cell in another workbook. For
example:

File #1 Name: test1
File #2 Name: test2

Lets say that cell a10 in file test2 is linked to cell a10 in file test1.
If I then sort file test1 and the record in row 10 is now in row 2, the cell
in file test2 is still pointing to cell a10 in file test1.

Any thoughts on how I can preserve the link to the original cell I linked
to???

Thanks in advance.

Darren