Here's my situation:

I have a group of folders that is routinely copied to an alternate
location. There are excel files contained within; some of them in the
main directory path, some within subfolders.

I've tried linking these excel workbooks together; however, when I
copy the directory tree, the only files that automatically update
their links are the ones that reside in the same folder. The files
that reside in a subfolder won't automatically update.

Is there a way to point Excel to a workbook using a relative link,
instead of the absolute link it uses by deafult? I know I can go into
each excel file and use Edit Links, but I'm looking for a method
that won't stress our less computer-savvy users.