how to change query in excel?
The Queries & Connections window will open, simply double-click on the name of a query. Within the Queries & Connections window, we can right-click on the query and select edit. When hovering over a query (don't click, just hover), Excel displays the query summary. Click the Edit option at the bottom.