Workaround: Excel hangs when launching MSQuery

This seems to be a problem for a lot of people, as there are at lot of pages asking how to fix this issue. The issue is that when you want to create a new query or edit a query that pulls data into Excel, Excel will attempt to launch MSQuery and hang, only displaying the message “waiting for data to be returned from microsoft query”.

Here is a very simple workaround:

1) First of all, create your query in MSQuery directly, then save the query somewhere.

2) Go to Excel, select Data –> Import External Data –> Import Data

3) In the “Select Data Source” dialog box, do not select the odbc connection to the db, instead select the query you created in MSQuery.

That’s it, the data will now import correctly, and the profile will save into your Excel worksheet as normal. Just thought I’d share this as I haven’t seen a solution posted anywhere.

2 comments

  1. My god… I’ve been trying to find a way to fix this for nearly 2 weeks now. I’ve found several false hopes but yours worked. IT WORKED.

    Thank you, thank you, thank you.

  2. Really glad it helped you. This problem drove me crazy for a while too, and I couldn't believe no one had posted a solution for it yet!

Leave a Reply

Your email address will not be published. Required fields are marked *