LINKS

M

moosehead

I have three excel workbooks. Two of them are linked to the third. When I
copy the three workbooks to my E Drive (from my C Drive) the path that the
linked cells is looking for remains the same ie it remains to be C:\Documents
& Settings.....etc rather than changing to E:\.....

any idea how I can fix this rather than using the "change source" feature as
I would like to be able to send these workbooks to a third party (offsite)
and have the links work the same as they do on my server.

thanks
 
A

Arvi Laanemets

Hi

Open all (three) source and target workbooks at same time. Use Save As to
copy both source workbooks to copy them to new destination. Use SaveAs to
copy the the target workbook to new deestination.
 
Top