How do I enable the criteria pane in MSQuery (Excel 2003)?
 

A Microsoft Query previously set-up in Excel 2000 does not show the Criteria
Pane when opening it in Excel 2003. Also, the criteria selections on the
toolbar have been greyed out and are, therefore, unchangeable. Is there a
setting that needs to be changed? The SQL code is still visible and
changeable, but my users are more comfortable seeing the criteria in
easy-to-understand column/row format. Any suggestions are welcome.

If the SQL code is uncomplicated (from MS Query's prespective), you should be
able to see the Criteria section by selecting ViewCriteria.

Otherwise, it probably means that the SQL has been edited such that MS Query
can't display it in the query editor windows.

Does that help?
--
Regards,
Ron