Closed External Workbook Link formula Inconsistently showing Last Saved Result

[Racz99]

I am using AverageIf to link to another workbook. I've read that the "if" family do not like source workbooks to be closed, so I was going to modify formulas to somehow use SumProduct, when I noticed that half of the instances of the formula did return results, while others returned #Value. Has anyone else noticed this happening? Why would it happen? I use Excel 2010 (14.0.7135.5000) SP2 MSO (14.0.7128.5000) Part of MS Office Professional Plus 2010

is displaying last saved result upon file open:
=$D42*AVERAGEIF('G:\source path\[file.xlsx]tab'!$A$2:$A$87,$B$39,'G:\source path\[file.xlsx]tab'!D$2:D$87)

is returning #value upon file open:
=$D72*AVERAGEIF('G:\source path\[file.xlsx]tab'!$A$2:$A$87,$B$69,'G:\source path\[file.xlsx]tab'!D$2:D$87)

 

[Racz99]

update ...I found the instances returning #value had a range of $a$2:$a$187, with second range ending at $d$87.
I'm still curious though as to whether or not there was an Excel update that is retaining saved results that reference closed external workbook using an AverageIf formula