referencing workbooks

[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

 

[Frank Kabel]

Hi
try openening all workbooks after moving them around. This should help

 

[anurag.d]

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

 

[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