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.

Hi

Open workbook A, and save it to new location (FileSave As ...)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"augustus" wrote in message
...
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.