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.