View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Error Editing an MS Query in Excel

Ignore the error message. Can you still do what you need to do?

"Chrisg" wrote:

I get an error when opening an MS Query in Excel "Query cannot be edited by
Query Wizard". If you click O.K all you can do is view and edit the SQL
Statement.
History:
Upgraded from MS Office 97 to MS Office 2007. Data source is AN IBM AS/400
using DB2 and OBDC Driver is the IBM Supplied Client Access OBDC Driver.

Any suggestions?
Thanks
Chris