[thelist] How do you edit a query in Excel 2007?

Rob Smith rob.smith at lexjet.com
Thu Jul 20 15:32:08 CDT 2006

This is more of a free tip than anything else. After grumbling and
mumbling in the new Excel 2007 Beta 2, here's how you edit a query:

1.       Click the properties in the data tab. 

2.       Click the button next to the connection

3.       Switch over to the definition tab

4.       Select the Command type as SQL

5.       Enter the query in the Command Text field.


...now if I could only get it to stop crashing!


Rob Smith
rob.smith at lexjet.com
(941)330-1210 Int'l
(941)330-1220 Fax
1680 Fruitville Road, 3rd Floor
Sarasota, FL 34236

More information about the thelist mailing list