Common issue with ODBC 64Bit OS 32Bit Office – System DNS does not appear in Query list
32bit path %systemdrive%\Windows\SysWoW64
64bit path %systemdrive%\Windows\System32
See:-
https://support.microsoft.com/en-us/kb/942976
or
http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/excel-2010-from-microsoft-query/