LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default "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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening Excel 2007 Christopher Excel Discussion (Misc queries) 4 December 22nd 06 01:32 PM
Excel 2003 Workbook I want to convert to Excel 2007 pglufkin Excel Discussion (Misc queries) 3 December 18th 06 07:06 PM
Changing to excel 2007 dpal Excel Worksheet Functions 2 December 7th 06 04:48 PM
Excel 2007 Cube access problems Mike L Excel Discussion (Misc queries) 5 October 10th 06 04:49 PM
Problematic chart issues in Excel 2007 azbull Charts and Charting in Excel 1 October 2nd 06 03:35 PM


All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"