I presume the OS in use here is Windows ?
Can you provide screenshots of the steps being performed in Excel, so we can see what the actions being performed and what is being displayed.
Can you also enable ODBC tracing and provide the generated ODBC trace of the ODBC calls being made.