laptop and a wrench

Bug

In ArcGIS for Excel, the automatic fill data in worksheet cells returns "#CALC!" errors intermittently when using the ARCGIS.ENRICHBYPOINT() function in Excel.

ArcGIS for Excel
Bug ID Number BUG-000167900
SubmittedMay 29, 2024
Last ModifiedSeptember 24, 2024
Applies toArcGIS for Excel
Version found2023.2
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusNon-Reproducible

Additional Information

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.

Steps to Reproduce

Bug ID: BUG-000167900

Software:

  • ArcGIS for Excel

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options