I have a workbook with cells that link to another workbook.

E.g.
=[Addon.xls]Main!$A$1

My issue is if the linked workbook closes the cell will update to its absolute path.

E.g.
='C:\Test\Plugin\[Addon.xls]Main'!$A$1

Is there anyway I can prevent this from happening as it returns a #VALUE error in my formula?

Kind regards,
Tom