We help IT Professionals succeed at work.
Get Started

MS Query doesn't give "Edit query" option

265 Views
Last Modified: 2012-05-12
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.

Any ideas?
Comment
Watch Question
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE