topic Re: Unable to open Excel with ArcMap 10.3... in Data Management Questions https://community.esri.com/t5/data-management-questions/unable-to-open-excel-with-arcmap-10-3/m-p/586883#M33155 <HTML><HEAD></HEAD><BODY><P>Thomas,</P><P></P><P>You are welcome!&nbsp; </P><P></P><P>Regards,</P><P></P><P>Tom</P></BODY></HTML> Mon, 25 Jan 2016 22:56:52 GMT TomSellsted 2016-01-25T22:56:52Z Unable to open Excel with ArcMap 10.3... https://community.esri.com/t5/data-management-questions/unable-to-open-excel-with-arcmap-10-3/m-p/586877#M33149 <HTML><HEAD></HEAD><BODY><P>Greetings!</P><P></P><P>I installed ArcGIS 10.3 and I am unable to open any spreadsheets directly in ArcMap.&nbsp; Using the Excel to Table tool works fine.&nbsp; Is this new at 10.3 or am I missing something?&nbsp; You used to be able use the Add Data tool without converting it.</P><P></P><P>Regards,</P><P></P><P>Tom</P></BODY></HTML> Thu, 08 Jan 2015 01:03:20 GMT https://community.esri.com/t5/data-management-questions/unable-to-open-excel-with-arcmap-10-3/m-p/586877#M33149 TomSellsted 2015-01-08T01:03:20Z Re: Unable to open Excel with ArcMap 10.3... https://community.esri.com/t5/data-management-questions/unable-to-open-excel-with-arcmap-10-3/m-p/586878#M33150 <HTML><HEAD></HEAD><BODY><P>Ok.&nbsp; The excel file was an xlsx format file not xls.&nbsp; Interesting that I can use the import tool, but not use the add data button.</P></BODY></HTML> Thu, 08 Jan 2015 16:19:02 GMT https://community.esri.com/t5/data-management-questions/unable-to-open-excel-with-arcmap-10-3/m-p/586878#M33150 TomSellsted 2015-01-08T16:19:02Z Re: Unable to open Excel with ArcMap 10.3... https://community.esri.com/t5/data-management-questions/unable-to-open-excel-with-arcmap-10-3/m-p/586879#M33151 <HTML><HEAD></HEAD><BODY><P>I was missing the 2007 Office System Driver: Data Connectivity Components.&nbsp; You can find them here:</P><P></P><P><A href="http://www.microsoft.com/en-us/download/details.aspx?id=23734" title="http://www.microsoft.com/en-us/download/details.aspx?id=23734">Download 2007 Office System Driver: Data Connectivity Components from Official Microsoft Download Center</A> </P><P></P><P>After loading the connectivity components the add data works correctly.&nbsp; I had a later version of Office on my pc, but still needed to install these components.</P></BODY></HTML> Thu, 08 Jan 2015 16:47:20 GMT https://community.esri.com/t5/data-management-questions/unable-to-open-excel-with-arcmap-10-3/m-p/586879#M33151 TomSellsted 2015-01-08T16:47:20Z Re: Unable to open Excel with ArcMap 10.3... https://community.esri.com/t5/data-management-questions/unable-to-open-excel-with-arcmap-10-3/m-p/586880#M33152 <HTML><HEAD></HEAD><BODY><P>We are operating office 2013 as well as ArcGIS 10.2.2 and it will only recognise xls files. Is there a solution to this apart from saving the xlsx as a xls?</P><P></P><P>Regards</P><P>Hellen</P></BODY></HTML> Sun, 11 Jan 2015 19:55:18 GMT https://community.esri.com/t5/data-management-questions/unable-to-open-excel-with-arcmap-10-3/m-p/586880#M33152 HellenSimpson 2015-01-11T19:55:18Z Re: Unable to open Excel with ArcMap 10.3... https://community.esri.com/t5/data-management-questions/unable-to-open-excel-with-arcmap-10-3/m-p/586881#M33153 <HTML><HEAD></HEAD><BODY><P>Hellen,</P><P></P><P>Yes!&nbsp; You should download and install the <SPAN style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif; font-size: 14.3999996185303px;">2007 Office System Driver: Data Connectivity Components.&nbsp; ArcGIS must need this specific version of the driver to be able to read xlsx files.&nbsp; Having a more recent version like Office 2013 would seem like it would have all of the previous drivers/components, but it doesn't.&nbsp; Click on the link shown above to get to the right driver.</SPAN></P><P></P><P><SPAN style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif; font-size: 14.3999996185303px;">I hope this helps!</SPAN></P><P></P><P><SPAN style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif; font-size: 14.3999996185303px;">Best Regards,</SPAN></P><P></P><P><SPAN style="font-family: arial, helvetica, 'helvetica neue', verdana, sans-serif; font-size: 14.3999996185303px;">Tom</SPAN></P></BODY></HTML> Mon, 12 Jan 2015 16:01:12 GMT https://community.esri.com/t5/data-management-questions/unable-to-open-excel-with-arcmap-10-3/m-p/586881#M33153 TomSellsted 2015-01-12T16:01:12Z Re: Unable to open Excel with ArcMap 10.3... https://community.esri.com/t5/data-management-questions/unable-to-open-excel-with-arcmap-10-3/m-p/586882#M33154 <HTML><HEAD></HEAD><BODY><P>Thanks Tom!!</P><P>This totally fixed my exact issue.</P><P></P><P>Tom</P></BODY></HTML> Mon, 25 Jan 2016 21:42:52 GMT https://community.esri.com/t5/data-management-questions/unable-to-open-excel-with-arcmap-10-3/m-p/586882#M33154 ThomasHoman 2016-01-25T21:42:52Z Re: Unable to open Excel with ArcMap 10.3... https://community.esri.com/t5/data-management-questions/unable-to-open-excel-with-arcmap-10-3/m-p/586883#M33155 <HTML><HEAD></HEAD><BODY><P>Thomas,</P><P></P><P>You are welcome!&nbsp; </P><P></P><P>Regards,</P><P></P><P>Tom</P></BODY></HTML> Mon, 25 Jan 2016 22:56:52 GMT https://community.esri.com/t5/data-management-questions/unable-to-open-excel-with-arcmap-10-3/m-p/586883#M33155 TomSellsted 2016-01-25T22:56:52Z