In ArcGIS for Excel, the automatic fill data in worksheet cells returns "#CALC!" errors intermittently when using the ARCGIS.ENRICHBYPOINT() function in Excel.
The incorrect variable is entered in the function (=ARCGIS.ENRICHBYPOINT($B2, $C2, , 3, "Miles", , "householdincome.MEDHINC_CY"). Once the variable is corrected, the function builder is able to correctly provide analysis result.