XFGet formulas return #Refresh when used in a large file and the XFGet contains an argument that points to a formula and not a hard coded value. This seems to be especially the case when the XFGet is used to retrieve FxRates. For example: =IF(P5=