I've opened a new Excel 2007 workbook and created an external data range using MS Query. I now want to edit the query, so I right-click in the data range, expecting the "Edit query" option that's usually there, but it's not there. I went to the Data ribbon, and everything in the Get External Data section is grayed out.
I've written (and edited) lots of queries like this from within Excel, so it's not that I don't know what I'm looking for. We've recently switched from MS Office 2003 to 2007 (I know, we're a little late to the party), and this problem has been dogging me ever since. The thing is, sometimes when I right-click in an external data range, I do get the "Edit query" option, and sometimes I don't. At first I thought it had something to do with the queries having originally been written in Office 2003 and maybe something didn't translate well when we went to 2007, but now I'm writing new queries in 2007 and getting the same thing. By the way, it makes no difference whether I'm in a workbook with the .xls extension or the .xlsx extension.
In the interest of full disclosure, I know that I can go to the Connections group on the Data ribbon, click Properties, go to the Definition tab, and click the Edit Query button, but that's not what I'm looking for. I want to know why I don't always have the Edit Query option when I right-click within an external data range.