ODBC Excel Connection - Key Not Present

[Steve Young]

I've installed the MySQL for Excel 1.3.8 as well as the ODBC 8.0.29. The add in correctly installed to Excel. When I go to the data tab I can see MySQL there. It lists my connections correctly however when I double click on any of them (local or on a hosted server) I receive the following error.

Connection Attempt Failed
The given key was not present in the dictionary.

This connection works when I go to workbench I'm able to open the data base immediately. My credentials are correct.

I tried using a bad password and it stopped me stating the credentials were bad so I also checked and changed the collation of the databases and tables on my local because someone was suggesting that as a possibility in a separate thread.

I've also tried installing an older odbc connector as well as 32 bit versions.

I'm rather stumped on this as it's not giving me a more detailed error and I am able to access it through workbench. Has anyone run across this or have suggestions to try?