View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Query Wizard Cannot Be Used To Edit This Query

If you click OK, Microsoft Query should open, and you can edit the
source file name in the SQL string.

Carl wrote:
I am trying to edit a query in an Excel worksheet to change the name of the
source file but keep getting the message, "Query wizard cannot be used to
edit this query". The worksheet is not protected. Does anyone have a
suggestion? Thanks in advance.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html