topic Re: 5.0 Excel Map won't Import Any Excel Data in ArcGIS for Office Questions

5.0 Excel Map won't Import Any Excel Data

KevinRyan1 — Thu, 14 Feb 2019 19:21:31 GMT

Downloaded the new 5.0 update. I can't get any excel records into the map. I keep getting "An error occurred while processing this action. Please try again." when I select excel data from the map window. I can add layers from portal. Is anyone experiencing a similar issue?

Re: 5.0 Excel Map won't Import Any Excel Data

ShannonChavez — Tue, 19 Feb 2019 21:45:50 GMT

Good Afternoon Kevin...Thank you for your post here! I have a few questions to hopefully help guide us towards a resolution. Please see my questions below:

What type of data are we working within your excel sheet (addresses, xy coordinates, etc)?
Is the error specific to a worksheet or opening up any worksheets (with existing or blank)?
Have you uninstalled and tried reinstalling Map for Office extension (perhaps this was a 'bad' install)?

Let me know your thoughts or findings.

Best,

Shannon | Product Engineer

Re: 5.0 Excel Map won't Import Any Excel Data

KevinRyan1 — Fri, 15 Mar 2019 13:28:02 GMT

We solved the problem: Arc for office users need to have publisher privileges (we ended up make a custom role for our org).

Re: 5.0 Excel Map won't Import Any Excel Data

AliciaRitzenthaler — Thu, 18 Jul 2019 20:11:48 GMT

Hi Shannon,

I'm having a very similar issue. I downloaded the Map for Office extension just today (ArcGISMapsForOffice_x64_5.0.1_en.exe). When I open Excel I see the ARCGIS MAPS tab, I can sign in successfully, but when I go to "Add Map" it refuses to load data from excel - it just hangs loading and loading and loading. I can add data from the ArcGIS data tab without any problem. I am signed into an account with an Admin role and permission to publish. I've got x,y coordinates not addresses. I've tried opening from several different excel files (both with existing coordinates and blank).

Any suggestions?

Re: 5.0 Excel Map won't Import Any Excel Data

ShannonChavez — Fri, 19 Jul 2019 17:01:44 GMT

Good Morning Alicia,

Are you experiencing this issue currently? Could you also confirm you are using version 5.0.1and perhaps, upload a sample of your data here?

All the best,

Shannon | Product Engineer

Re: 5.0 Excel Map won't Import Any Excel Data

TracySchloss — Tue, 23 Jul 2019 20:36:40 GMT

I feel like this ties to my question about not being able to load my worksheet of county data. I have publisher permission, so that can't be a solution for me. Good tip, though for the future, since not all my users will have publisher permission. I would have expected them to create content within Excel, and that Publisher would come into play as they shared out their content.

I need to think through the various permissions people will need. I understand the need for a named user account, but just because a user can create their own content doesn't mean I would want them to publish it to Everyone.

Re: 5.0 Excel Map won't Import Any Excel Data

AliciaRitzenthaler — Tue, 30 Jul 2019 20:31:34 GMT

Hi Shannon,

I'm still experiencing the same problem. I do in fact have version 5.0.1.

Re: 5.0 Excel Map won't Import Any Excel Data

TracySchloss — Tue, 30 Jul 2019 20:49:02 GMT

I was able to display coordinates just yesterday, about 4500 records, and I have version 5.0.1 too, so it's not failing for everyone. I notice your coordinates have a LOT of decimal places. I wonder if its getting hung up on those? Have you tried creating a variation of your columns that has fewer?

Re: 5.0 Excel Map won't Import Any Excel Data

AliciaRitzenthaler — Tue, 30 Jul 2019 21:02:46 GMT

I've tried no trailing zeros and without decimal altogether. I've also tried changing the field format from numeric to general and to text. No luck yet.

Re: 5.0 Excel Map won't Import Any Excel Data

TracySchloss — Tue, 30 Jul 2019 21:18:18 GMT

Has this worked for you in past versions? For me, I had to try 3-4 different map projections before I happened on the right one. The source of the data I was using didn't give enough details for what their coordinates were in, they just said NAD 83, State Plane. That's still a long list for every state and I had to try a few before it worked. Before then, my points were in Michigan instead of Missouri.

Re: 5.0 Excel Map won't Import Any Excel Data

ShannonChavez — Tue, 30 Jul 2019 21:19:08 GMT

Thanks Alicia, @Tracy had a great suggestion to start eliminating possible causes. Also, is this xy data the orginal worksheet or did you use the tool to add xy coordinates from Maps for Office?

One more suggestion, check the coordinate system being used. I had this happen to me before and it was because I was using the wrong projection.

Here is the link for our online documentation, it maybe useful - https://doc.arcgis.com/en/maps-for-office/design-and-use/add-coordinates.htm

Best,