Reporting and Analysis
for GoldMine CRM and QuoteWerks quote management
Support Center > Knowledge base> Article: This query cannot be edited by the Query Wizard

This query cannot be edited by the Query Wizard

Article ID: 31685

Question
This query cannot be edited by the Query Wizard

Answer

More an annoyance than a bug, this message results when Excel tries to load MasterMine's query into a query wizard for editing, instead of going directly into MS Query which is more capable of handling complex queries. To speed up loading of MSQuery and remove this annoyance, do the following one time in Excel:

  1. On the 'Data' Menu, select ""Get External Data..."" and ""New Database Query""
  2. On the dialog that comes up, find the checkbox for ""Use the Query Wizard to create/edit queries"" at the bottom and uncheck it.
  3. Exit this dialog by hitting ""Cancel"".
"

related articles

Article Details
Views: 1361 Created on: Nov 15, 2016

Please let us know what you think of this article.
Poor
Outstanding