topic maps for office in Developers Questions https://community.esri.com/t5/developers-questions/maps-for-office/m-p/165589#M1002 <HTML><HEAD></HEAD><BODY><P>Hi, I've been trying to create a layer out of an excel table with many different columns which two of them are coordinates with a different spatial reference then the default one. i'm using 2039. When the data is being added to the map, it shows up perfectly for a second and then disappears.. the map says all the point were marked as errors! any idea why is that??</P></BODY></HTML> Wed, 11 Nov 2015 19:02:19 GMT SvivaManager 2015-11-11T19:02:19Z maps for office https://community.esri.com/t5/developers-questions/maps-for-office/m-p/165589#M1002 <HTML><HEAD></HEAD><BODY><P>Hi, I've been trying to create a layer out of an excel table with many different columns which two of them are coordinates with a different spatial reference then the default one. i'm using 2039. When the data is being added to the map, it shows up perfectly for a second and then disappears.. the map says all the point were marked as errors! any idea why is that??</P></BODY></HTML> Wed, 11 Nov 2015 19:02:19 GMT https://community.esri.com/t5/developers-questions/maps-for-office/m-p/165589#M1002 SvivaManager 2015-11-11T19:02:19Z Re: maps for office https://community.esri.com/t5/developers-questions/maps-for-office/m-p/165590#M1003 <HTML><HEAD></HEAD><BODY><P>Hi Sviva,</P><P></P><P>Would you be able to upload a sample of your excel spreadsheet?</P></BODY></HTML> Wed, 11 Nov 2015 19:08:56 GMT https://community.esri.com/t5/developers-questions/maps-for-office/m-p/165590#M1003 JakeSkinner 2015-11-11T19:08:56Z Re: maps for office https://community.esri.com/t5/developers-questions/maps-for-office/m-p/165591#M1004 <HTML><HEAD></HEAD><BODY><P>Hi Jake, thanks for the quick reply.</P><P>I was just about to reply to you that I've tested it on a smaller sheet and it worked out fine and while going back to take a screen shot all points disappeared again and marked as errors! so weird.</P><P></P><P>I attached the excel and screenshot of the error</P><P>I suspect it might work at your side because of basemaps with a different spatial reference - in my case I can choose only my own basemaps which all have a unique spatial reference.. not web mercator that is</P></BODY></HTML> Wed, 11 Nov 2015 19:18:31 GMT https://community.esri.com/t5/developers-questions/maps-for-office/m-p/165591#M1004 SvivaManager 2015-11-11T19:18:31Z Re: maps for office https://community.esri.com/t5/developers-questions/maps-for-office/m-p/165592#M1005 <HTML><HEAD></HEAD><BODY><P>Sviva,</P><P></P><P>Have you selected the spatial reference in the Add data from my spreadsheet dialog to match your data?</P><P></P><P><IMG alt="maps_for_office_sr_other.jpg" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/141766_maps_for_office_sr_other.jpg" style="width: 620px; height: 541px;" /></P></BODY></HTML> Wed, 11 Nov 2015 19:21:02 GMT https://community.esri.com/t5/developers-questions/maps-for-office/m-p/165592#M1005 KyleBalke__GISP 2015-11-11T19:21:02Z Re: maps for office https://community.esri.com/t5/developers-questions/maps-for-office/m-p/165593#M1006 <HTML><HEAD></HEAD><BODY><P>What is the coordinate system of your basemaps?</P></BODY></HTML> Wed, 11 Nov 2015 19:34:54 GMT https://community.esri.com/t5/developers-questions/maps-for-office/m-p/165593#M1006 JakeSkinner 2015-11-11T19:34:54Z Re: maps for office https://community.esri.com/t5/developers-questions/maps-for-office/m-p/165594#M1007 <HTML><HEAD></HEAD><BODY><P>My basemap's spatial reference is 2039... What Kyle wrote fixed my problem <IMG src="https://community.esri.com/legacyfs/online/emoticons/happy.png" /> I didn't notice that option. thanks</P></BODY></HTML> Thu, 12 Nov 2015 06:17:58 GMT https://community.esri.com/t5/developers-questions/maps-for-office/m-p/165594#M1007 SvivaManager 2015-11-12T06:17:58Z Re: maps for office https://community.esri.com/t5/developers-questions/maps-for-office/m-p/165595#M1008 <HTML><HEAD></HEAD><BODY><P>Thank you Kyle, I didn't even notice that option exists.. It solved my problem.</P><P></P><P>A bit irrelevant but any idea if all types of named users can have this plug-in for excel to use?</P><P>For ArcGIS Pro for example you need to be a named user with a desktop license.</P></BODY></HTML> Thu, 12 Nov 2015 06:22:08 GMT https://community.esri.com/t5/developers-questions/maps-for-office/m-p/165595#M1008 SvivaManager 2015-11-12T06:22:08Z Re: maps for office https://community.esri.com/t5/developers-questions/maps-for-office/m-p/165596#M1009 <HTML><HEAD></HEAD><BODY><P>Esri Maps for Office does require a named user on an ArcGIS Online for Organizations subscription.&nbsp; No desktop license required.</P><P></P><P>See the System Requirements section</P><P><A href="http://doc.arcgis.com/en/maps-for-office/" title="http://doc.arcgis.com/en/maps-for-office/">Esri Maps for Office | ArcGIS</A> </P></BODY></HTML> Thu, 12 Nov 2015 15:34:11 GMT https://community.esri.com/t5/developers-questions/maps-for-office/m-p/165596#M1009 KyleBalke__GISP 2015-11-12T15:34:11Z