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

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

"Koppite412" wrote:

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