Sometimes AFE seems to stop properly updating functions. I can't figure out the circumstances, but sometimes the only solution I've found is to entirely recreate a workbook from scratch, which obviously isn't an ideal solution.
You can see in these screenshots that AFE is synchronized with the workbook, but the function is not returning what it should be. I can share the workbook if need be.
