Share via

Can not use query edit and parameter in Excel of office365

Anonymous
2017-04-12T07:12:57+00:00

Hi,

can you please advise why I can not edit query and parameter? thanks.

Regards

Steven

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2017-04-20T13:57:54+00:00

    Hi Steven,

    Glad to hear that you found a workaround.  I’d like to write a summary to help other members easily see the information.

    Issue description:

    1. Using an OLE DB Query, the Edit Query button is greyed out.
    2. Using an OLE DB Query, entering a query that uses a question mark (?) as a parameter on the Command text shows an error indicating you need to set the parameter.

    Solution:

    1. If you are using an OLE DB Query, you can change the query via the Command text area. The Edit Query button is available if you are using a Microsoft Query.
    2. If you are using an OLE DB Query, it is not feasible to enter a question mark (?) as a parameter. As a workaround, you can use a Microsoft Query. You can then set the parameter using a question mark (?) in the Command text area.

    Thanks,

    Sheen

    4 people found this answer helpful.
    0 comments

11 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-04-12T09:02:14+00:00

    Hi Steven,

    You cannot edit the query if the connection information is currently linked to a connection file. Please make sure it not linked to another connection file.

    How did you create connection in Excel? Please refer to these steps and confirm if your steps correct.

    http://snippetsandhelp.blogspot.sg/2013/05/excel-2013-getting-data-from.html

    Or can you share your detailed steps to create connection in Excel, some screenshots would be appreciated.

    Regards,

    Linda

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2017-04-12T12:20:52+00:00

    Hi Linda,

    Here is the steps. just connect to sql directly.

    and also I tried another way, 

    Create query -> from database -> SQL database -> enter database username and password -> select table or view -> load. 

    Regards

    Steven

    0 comments
  3. Anonymous
    2017-04-13T11:03:51+00:00

    Hi Steven,

    Thanks for your information.

    Have you tried the above links? If the issue persists, I would like to confirm the following information:

    1. A screenshot of the Office version you are using.
    2. Do all worksheet have the same issue or just in specific sheet and database.

    Rgeards,

    Linda

    0 comments
  4. Anonymous
    2017-04-16T09:49:36+00:00

    Hi Steven,

    Any updates?

    Regards,

    Linda

    0 comments