Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Opening Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2003 Workbook I want to convert to Excel 2007 | Excel Discussion (Misc queries) | |||
Changing to excel 2007 | Excel Worksheet Functions | |||
Excel 2007 Cube access problems | Excel Discussion (Misc queries) | |||
Problematic chart issues in Excel 2007 | Charts and Charting in Excel |