Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"edit query" button in Excel 2007 has been hidden | Excel Worksheet Functions | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
is there a way to get the right click edit menu in Excel 2003? | Excel Discussion (Misc queries) | |||
HOW DO I EDIT RIGHT CLICK MENUS IN EXCEL? | Excel Discussion (Misc queries) | |||
Edit query in excel 2000 | Excel Discussion (Misc queries) |