Sorry, but it looks like there is no workaround or resoslution on this.

"madge" wrote:

I have this same need too. Did you find a solution? Thanks!

"Juana Cafe" wrote:

When creating a linking formula with other workbooks, the cell references
destination (parent) workbook default to absolute. I cannot find a setting to
change this to relative.