waiting for data to be returned from microsoft query

  • Thread starter Thread starter jb
  • Start date Start date
J

jb

When I go into Data/Get External Data/New Database Query I
get this "Waiting for data to be returned from Microsoft
Query". I have completely removed Excel and reinstalled.
Occasionally 1 out of 100, the ODBC Data Sources will
appear, but very seldom.
 
Solution For the Issue

Dear Friends,

Even i was getting the same error from months.
Also couldn't get any solution from most of the forums.

Finally i could debug it myself.

Error i Was Getting when trying to Get external data from new database query:
In the excel status bar it was showing "Waiting for data to be returned from microsoft Query" and the excel would hang.

Operating System Using : Windows XP
Microsoft Office Version : Office 2000
Oracle Database Using : Oracle 9i

Solution: (Am not sure if this works for every one, but no harm in trying)
1) Open a blank excel
2) Go to tools menu --> Click on Add-Ins
3) You would find MS Query Add-in and ODBC Add-in
4) Make sure to check the boxes against these 2 Add-Ins
5) Click OK and close the excel
6) Restart the system (Very important step)
7) Open a blank excel
8) Go to Data menu --> Get External Data --> New Database Query
9) Within few seconds --> Choose Data Source window will pop up

:thumb:

Regards
Chandru
 
Back
Top