Referencing other workbooks

[augustus]

Hi,

I have got a workbook (Workbook A, say path = L:\Design) reference to a
table in another workbook (Workbook B, say path = L:\Design\ST). However,
when I copy Workbook A to My Documents (path = C:\Documents and
Settings\aug\My Documents) the external link also automatically updated (path
= C:\Documents and Settings\aug\My Documents\ST). How could I structure the
link so that always potin to where Workbook B is actually stored, no matter
where I store Workbook A?

Thanks.

 

[Arvi Laanemets]

Hi

Open workbook A, and save it to new location (File>Save As ...)