"edit query" button in Excel 2007 has been hidden
 

Hello everyone,

We recently upgraded some of our users from Office 2002 to Office 2007.
Most of our managers are used to running queries through the Excel query
wizard.

In Excel 2007 there was an "Edit Query" button visible in the tool bar that
allowed users to go back into the query wizard and change the query fields,
filtering and sort criteria. Having that button in the Excel toolbar was
easy and convenient.

In Excel 2007 the Edit Query button has been moved to Data -- Existing
Connections -- Workbook connection properties -- Definition Tab -- Edit
Query. This is driving users, especially our vice president, nuts.

Is there any way of placing a shortcut to the edit query button in the
ribbon itself so it's easier to reach?

Thanks in advance,

Andre Ranieri

PS Access isn't an option for most of our users because we don't want them
running amok through the database with action queries.

Answer: "edit query" button in Excel 2007 has been hidden
 

Hi Andre,

I understand how frustrating it can be when a commonly used feature is moved to a less convenient location. Fortunately, there is a way to add a shortcut to the Edit Query button in the ribbon.

Here are the steps to do so:

1. Right-click on the ribbon and select "Customize the Ribbon".
2. In the right-hand pane, select the tab where you want to add the shortcut (e.g. "Data").
3. Click on the "New Group" button to create a new group within that tab.
4. Select the new group and click on the "Rename" button to give it a name (e.g. "Query").
5. With the new group selected, click on the "Choose Commands From" drop-down menu and select "Commands Not in the Ribbon".
6. Scroll down the list until you find "Edit Query" and select it.
7. Click on the "Add" button to add it to the new group.
8. Click on "OK" to close the Excel Options window.

Now you should see a new group in the ribbon with the Edit Query button in it. You can also customize the icon and tooltip for the button by right-clicking on it and selecting "Change Button Image" or "Edit Button Image".

"edit query" button in Excel 2007 has been hidden
 

I don't have office 2007 in front of me and so can't verify this, but I think
this will help you: http://blogs.msdn.com/excel/archive/...10/549309.aspx

Dave
--
Brevity is the soul of wit.


"Andre Ranieri" wrote:

Hello everyone,

We recently upgraded some of our users from Office 2002 to Office 2007.
Most of our managers are used to running queries through the Excel query
wizard.

In Excel 2007 there was an "Edit Query" button visible in the tool bar that
allowed users to go back into the query wizard and change the query fields,
filtering and sort criteria. Having that button in the Excel toolbar was
easy and convenient.

In Excel 2007 the Edit Query button has been moved to Data -- Existing
Connections -- Workbook connection properties -- Definition Tab -- Edit
Query. This is driving users, especially our vice president, nuts.

Is there any way of placing a shortcut to the edit query button in the
ribbon itself so it's easier to reach?

Thanks in advance,

Andre Ranieri

PS Access isn't an option for most of our users because we don't want them
running amok through the database with action queries.