Query Options

This is the last step of the wizard and allows you to specify options that control the insertion and ongoing behavior of the query.

Query Name

Use this box to specify a name for the query. The range of cells occupied by the query results will be assigned this name (which will appear in the Name Box drop-down list). In addition, when you edit a query, the name that you assign here is displayed in the list of available queries. The default name is based on the name of the primary table for the query.

Destination (upper-left corner)

Use this box to specify the location of the query on your worksheet. The default location is based on the current cell selection prior to starting the wizard. You can click the drop-down list to select from named cells. You can also click the cell-selector button in order to point and click on the desired cell in your worksheet. Take care not to let the query you are inserting overlap with another query that is already on the worksheet.

Data Options

Insert as a table that can be refreshed with live dataSelect this option if you want the ability to use the query in the future to get current data. Refreshing the query at a later time may result in new rows being added or rows being removed based on the data currently stored in your database.
Insert as a table of static data (that cannot be refreshed)Select this option if you only intend to run the query once in order to get a list of static values into your worksheet.
Exclude duplicate rowsIf checked, this ensures that the combination of values on any given row is unique. This can be useful when needing to build a list of distinct values that are present in a more detailed table.


Include column captionsCheck this box to include a header row at the top of the query results that displays captions for each column.
Maintain column widths to fit dataCheck this box to allow columns to resize automatically whenever the query is refreshed. Leave this box unchecked if you want to set your own column widths and have them persist.
Move existing columns to make room for the queryCheck this box to ensure that when the query is inserted, existing columns will not be overwritten. Any existing columns will be shifted to the right.