I'd like to make a workbook and its linked-to workbooks portable i.e., independent of what hard drive etc. they occupy . . .

All the workbooks will be in one folder. But I'd like to be able to vary that folder -- I'd like to be able to copy it to a USB drive, for example, and open the 'parent' workbook and have it look in the right place for referred-to cells. The right place in this case would be in workbook(s) that are in the folder on the USB drive where the parent workbook is located.

What I'm encountering is Excel's inability to refer to linked-to workbooks when they are not in the subdirectory that they were in when originally made.

Any/all help is much appreciated!