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.