Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-22-2016, 06:25 PM
bl10 bl10 is offline Query and Power Query not working Excel 2016 Windows 10 Query and Power Query not working Excel 2016 Office 2016
Novice
Query and Power Query not working Excel 2016
 
Join Date: Jul 2016
Posts: 1
bl10 is on a distinguished road
Default Query and Power Query not working Excel 2016

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Web Query error dmcg9760 Excel Programming 0 12-25-2015 11:42 PM
Query and Power Query not working Excel 2016 Microsoft Excel Query 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
Query and Power Query not working Excel 2016 Need an Automated sql query for the Excel file Karthick Excel 3 12-20-2010 04:52 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 10:38 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft