![]() |
|
#1
|
|||
|
|||
![]()
Old Query, get data from other sources, gets error message:
Microsoft query cannot be started because it is not installed ............. The effect is that it doesn't open the choose data source dialog box. (it used to work ok but apparently the integration of Power Query broke it). It does, however, open the actual Microsoft Query and if I click on New Query it opens the choose data source dialog box all works as before except there doesn't seem to be a way to load the query into the actual spreadsheet. Obviously query is installed but some config link is broken. I have spent hours with the help board to no avail and have tried everything I can think of. Power Query goes to the DSN choose box ok but only displays the 1st data base for selection rather than the entire list. Windows 10 pro insider build Ver 1607 build 1439.0. Office 2016 pro. version 16.0.707.2028 All updates in place. Am at a loss as to what to try next. Barry |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Web Query error | dmcg9760 | Excel Programming | 0 | 12-25-2015 11:42 PM |
![]() |
Amt64 | Excel | 1 | 04-30-2014 09:05 AM |
Compound Countifs Query not working | Lonercom | Excel | 5 | 06-28-2013 10:27 AM |
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? | mag | Excel | 0 | 10-18-2012 11:15 AM |
![]() |
Karthick | Excel | 3 | 12-20-2010 04:52 AM |