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

[Pål_Herman_Sund]

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? 

[JonEmch · Accepted solution]

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.

[Pål_Herman_Sund]

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