Using full row/column addresses in formulas referencing external workbooks causes performance issues

[JanKallman]

Using an addresses to a full column/row external addresses does not correct the address to the external worksheets dimension causing some formulas have bad performace.