excel 2007 right click edit query

K

Koppite412

Hi Folks

New to Excel 2007, seasoned at Excel 2003.

I have set up an ODBC query, run it in MS Query and returned the data to
Excel 2007. On my previous version (2003) I could right click anywhere on
the returned data, select Edit Query from the pop up menu and get back to MS
Query to amend the query as I wanted.

I cannot find the same functionality in Excel 2007.

Is this because MS have changed things around, or is this because the query
is disconnecting from the database/datasource as soon as it returns the data
and therefore cannot edit/refresh? If it is the latter, what do I need to do
to prevent it?

Thanks in advance
 
D

Duke Carey

When you right-click you should see Table on the pop-up menu. Under Table is
an option to Edit Query
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Editing Queries In Excel 2007 1
Insert subtotal in a query database Excel 2007 3
excel crashes when changing web query 0
MS Query has data, but does not transfer it to Excel 2
Excel 2003 query from Access 2000 database 1
Error Editing an MS Query in Excel 1
Excel 2007 / right-click / pick from drop down list 1
Query Wizard - Choose Columns 3

Top