I recently had my work laptop installed with Windows 10 Enterprise 64Bit and office 2016 32Bit.
Now when I want to open MS Query from Excel by selecting "Data -> From Other Sources -> From Microsoft Query", the MS Query application launches minimized and Excel hangs for about 10-20 seconds before displaying an alert with:
Microsoft Query could not be started because it isn't installed. You can install Query by running the installation program you used to intall Office or Excel. The Query option is in the Office Tools category.
Usually MS Query displays a dialog to select an ODBC data source but this dialog never comes.
I've seen other computers running with the same Windows/Office image where MS Query is launching with the "Select data source" dialog as it should.
I've tried to running Office repair, remove/add the Query component from the office installation, remove any ODBC drivers that didn't ship with Windows/Office, and updated Excel with all available updates. But still no luck.
Anyone who can point me in the right direction to solve this error?