topic Re: Excel - Maps for Office can not find data (Named Range, Range nor Table) in ArcGIS for Office Questions

Excel - Maps for Office can not find data (Named Range, Range nor Table)

Pål_Herman_Sund — Thu, 14 Jan 2021 11:18:34 GMT

Hi. I sm preparing to host some training where one intention was to show Maps for Office with data in Excel. Actually testing with a sample form the AGON class (chapter 4).

Tried on 2 PC's
- Win 64-bit on both machines
- Office 32 bit 2012 on one machine, and Office 64 bit 2020 on the other
- Norwegian locale on both machines

On both machines all functionality seems to work (make slide, add layers, change basemap etc) BUT on neither machines Maps for Office is able to find my Excel data. That goes for both data as just a range, a named range or a table. Anyone seen this before and help with a solution?

Re: Excel - Maps for Office can not find data (Named Range, Range nor Table)

JonEmch — Tue, 19 Jan 2021 14:33:18 GMT

Hello there!

In my experience, this behavior is actually a symptom of a potential bad geolocator that has been configured in your ArcGIS Online / Enterprise organization. Please confirm that all configured geolocator URL's are accessible from your ArcGIS Online host org.

Re: Excel - Maps for Office can not find data (Named Range, Range nor Table)

Pål_Herman_Sund — Tue, 19 Jan 2021 15:17:29 GMT

Thanks @JonEmch that was spot on! One of the Locators available had had a broken URL. Many thanks! pH