referencing workbooks

R

richardDex

I have a small problem with referencing workbooks. There is a workboo
set as a parent with a number of child workbooks reference. These chil
workbooks also reference the parent which is one directory up. Th
problem occurs when the main directory holding all the workbooks an
subfolders is moved. The references in the parent to child links ar
updated but the child to parent aren't. Any ideas on how to get aroun
this
 
A

anurag.d

Open Edit, Links in ur child workbooks.Change the reference to point t
the correct location of the parent file
 
R

richardDex

thanks guys I was hoping that here was some way of automating this du
to the large number of links contained in the workbooks but if this i
the only way...aw well.:rolleyes
 
Top