software

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 (Filegt;Save As ...)--
Arvi Laanemets
( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
quot;augustusquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I have got a workbook (Workbook A, say path = L:\Design) reference to a
gt; table in another workbook (Workbook B, say path = L:\Design\ST). However,
gt; when I copy Workbook A to My Documents (path = C:\Documents and
gt; Settings\aug\My Documents) the external link also automatically updated
gt; (path
gt; = C:\Documents and Settings\aug\My Documents\ST). How could I structure
gt; the
gt; link so that always potin to where Workbook B is actually stored, no
gt; matter
gt; where I store Workbook A?
gt;
gt; Thanks.