Saving linked workbooks to another directory

K

K. Georgiadis

My Excel manual is not at all clear on this rather basic
topic, so let me reassure myself by asking you people:

I have two linked workbooks that will be submitted as
email attachments to a colleague of mine. Upon receipt,
he will save these two workbooks to his hard drive. What
is the saving procedure to maintain the integrity of the
links, so that he does not need to restore them manually?
 
A

Arvi Laanemets

Hi

Easiest is to save them to folder with exactly same path. An example:

You have 2 workbooks somewhere on your computer. Open both of them, and then
SaveAs them to My Documents (C:\My Documents) folder (when they were
elsewhere before). Send thm via e-mail.
Your colleague saves both attatchments into My Documents folder. When he
want to move them to another location, he opens them both, and uses SaveAs.

It will be much easier when both of you have some network resource
available, where the workbooks can be stored. You both map your network
resource with same letter, p.e. X, and store workbooks there. Now links in
workbooks are looking like:
='X:\[OtherWorkbook.xls]Sheet1'!A1
and real directory structure doesn't matter anymore.
 
Top