Fixed path to other workbooks
 

Is there a way to fix the directory that a workbook would "lookup" so that a
hub workbook can link to a series of others in the same directory.

If this was just for one directory I would not have a problem as I just
create the hub within the single directory.

However, in my case I am looking to create a single hub workbook that will
work in various directories where the satellite workbooks all have the same
names.

Currently, when I copy the hub workbook to the other directories it does not
identify the satellite workbooks that are in there unless I relink them all
again.

Hope this makes sense

Any help appreciated