If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
excel 2007 right click edit query
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 |
Thread Tools | |
Display Modes | |
|
|