topic ArcGIS Maps in Excel in ArcGIS for SharePoint Questions

ArcGIS Maps in Excel

AnareMOTOKULA — Wed, 12 Aug 2020 22:40:44 GMT

I am trying to add data to my sharepoint excelsheet add on @ArcGISMaps in excel however I cant seem to find my country when I am trying to specify locations and use the data from the excelsheet. The data collected is based on the provinces (admin boundary) of my country but I cant seem to add this as a boundary because my country is not even an option to add. I'm from Fiji by the way.

Re: ArcGIS Maps in Excel

DerekLaw — Mon, 17 Aug 2020 17:22:28 GMT

Hi Anare,

> I am trying to add data to my sharepoint excelsheet add on @ArcGISMaps in excel however I cant seem to find my country when I am trying to specify locations and use the data from the excelsheet.

Can you please clarify: are you using ArcGIS Maps for SharePoint or ArcGIS Maps for Office? The latter is the add-in that works within MS Excel - but you've posted in the discussion forum for the former.

Can you please describe your workflow in more detail, perhaps provide screenshots?

Re: ArcGIS Maps in Excel

AnareMOTOKULA — Tue, 18 Aug 2020 07:22:49 GMT

Hi Derek,

I have primarily been trying this in ArcGIS Maps for Office. And as seen below in the location type I would like to choose Fiji Admin Boundaries but this is not possible as Fiji is a country still not on here as an option.

Cheers

Anare

Re: ArcGIS Maps in Excel

DerekLaw — Tue, 18 Aug 2020 20:26:03 GMT

Hi Anare,

> I have primarily been trying this in ArcGIS Maps for Office. And as seen below in the location type I would like to choose Fiji Admin Boundaries but this is not possible as Fiji is a country still not on here as an option.

Thanks for the clarification. In the Data format dialog, after you select the records in your spreadsheet that you want to geocode; then in the Add data with location and map style dialog, for the Location type parameter, is Country not an option for you?

> The data collected is based on the provinces (admin boundary) of my country ...

I'm unsure if the world locator service has admin boundaries for Fiji.

Hope this helps,