LINKS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create absolue path link to another workbook (Excel 2003) 1
change links to a different source in the same workbook 2
Link Protection Forms 1
Looping PoewrPoint Show linked to Excel 2
Links 1
Are relative file locations possible in linking workbooks? 7
excel links 2
SQLServer 2012 Replication (using C#) 1

Back
Top