Can not use query edit and parameter in Excel of office365

Question

Hi,

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

Regards

Steven

Answer 1

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

Answer 2

Hi Linda,

here is the version, all worksheet have save issue.

I am guessing, is it caused by office365 subscription?

Regards

Steven

[Product ID is masked by Yoga Yao MSFT Support]

Answer 3

Hi Steven,

We would like to get your Office version, so that we can check it from our side in the same version. Please go to File> Account> Product Information, and capture a screenshot about the product information.

Regards,

Yoga

Answer 4

Hi Yogoa,

here is the version,

Regards

Steven

Answer 5

Hi Steven,

You can use the 'Edit Query' button to edit the query for MS Query type connections. I.e. those that you have started using the 'From other data sources > Microsoft Query' option. Such queries show 'Database query' at the top of the definition tab.

If you choose the 'Other data sources > SQL Server' option, you have to edit the query in the 'command text' box below the connection string box. You can't edit the query using MS query. that is why the 'Edit Query' button is disabled.

Regards,

Sheen