View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Koppite412 Koppite412 is offline
external usenet poster
 
Posts: 2
Default excel 2007 right click edit query

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