I have an excel file I use daily for work that I give an updated file name every few days by changing the date, i.e. PO Log 2018-10-08 would become PO Log 2018-10-10. This helps me feel better about losing minimal data in an unforeseen circumstance.

The workbook has a lot of tabs and information and can sometimes the data displayed can become a bit overwhelming so what I tried doing was embedding a separate excel file as an object inside the main parent file to clean the look up a bit. This embedded file is basically a table that I don't need to reference very often but I would like to have the parent document be able to pull data from the embedded document and vise versa. This works great when the formulas are first set up but as soon as I rename the parent document, the formulas in the embedded document always link back to the old revision of the parent file instead of the newly revised parent file name which is the file its embedded in.

Is there a workaround for this to force excel to always pull data from the file it's embedded in rather than it pulling an external reference from the outdated file name source workbook?

Any help would be appreciated - thanks