Issue with relative references between workbooks

Hi. I'd appreciate help on this issue. I need to reference different workbooks, which itself is not an issue, but I have a problem with retaining relative references between workbooks, so I can transfer them to another computer.

I've found out that relative references work fine in two cases:

a) If source workbook is in the same folder as destination workbook (root folder), or
b) If source workbook is in another folder within root folder, and destination workbook is in root folder.

However, if source workbook is in one folder within root folder, and destination workbook is in another folder within root folder, then relative references do not seem to work - Excel displays full path (C\users\user\folder..., etc.), and when I move entire root folder to another destination, references get broken and destination workbook cannot be updated.

I hope I managed to explained it well; I speak of this structure:

Root folder
-> Folder 1
--> Source workbook
-> Folder 2
--> Destination workbook

The structure must remain this way, source workbook must be in its own folder, and destination workbook in its own different folder. Is there a way to preserve relative references, so I can transfer root folder to another PC?

The same issue appears if source workbook is in root folder, and destination workbook is in another folder within root folder; although that specific case is not of interest for me.

It seems that destination file must be in the same folder as source workbook, or above that folder, must not be below that folder. Any way to circumvent it?

I have read the article here: https://support.microsoft.com/en-gb/kb/328440 , but it's not of much help for me.

Thanks for reply! I hoped there would be a method, to facilitate it at the time of creation the references, without editing them later.

If I have to edit them later, then it might be easier to do it the way I do it now - use "Replace" facility to replace old path with the new one within formulas.

Problem is that there are 365 source and destination workbooks, one per day, so it's annoying to keep updating the references...