Editing Microsoft Query in Excel 2007

[BMitchell422]

This may be a really easy question, but I have set up a few queries in Excel 2007 using Microsoft Query. In the older version of Excel, I would just have to right click and access the edit query function. However, in Excel 2007 when I right click, I only have the option to "Refresh", but I usually need to edit the query for a different month. The only way that I know how to do this is to go through Data -> Connections -> Properties -> Definition then Edit Query. Is there an easier way to edit a query once it is set up in 2007? Did I miss an option when I set up the query to be able to edit when I right click? Any help would be really appreciated!!!!!!!!

 

[beckys]

You may already know this, but you can right click, go to table, and edit query.

 

[BMitchell422]

That is awesome!! Thank you. I had not figured that out yet. I had just added a button to my custom toolbar to edit query in the time being, but that is very helpful. Thanks!!