- May 19, 2008
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!!!!!!!!