XL2001: Command Buttons Are Unavailable in FileMaker Import Wizard When You Edit Query (270104)


The information in this article applies to:

  • Microsoft Excel 2001 for Mac
This article was previously published under Q270104

SYMPTOMS

When you use the FileMaker Import Wizard to import data from FileMaker Pro into a Microsoft Excel 2001 workbook, and you apply filter criteria to the data, the following unexpected behavior occurs when you subsequently try to edit the query in Excel 2001:
  • Even though data fields appear in the Fields to import list, the Next button and the Finish button are not available (are dimmed), and it appears that Excel is unable to advance to the next step of the FileMaker Import Wizard.
  • When you are able to get to the next step, the field name and operation combo boxes for Criteria 2 and Criteria 3 are available (not dimmed), but they are blank, instead of displaying the default prompt "Pick a field" and "=" (the equal sign).

RESOLUTION

In the FileMaker Import Wizard, select one of the fields that already appears in the Fields to import list, and then click the Add (>) button as if to move that field to the Fields to import list again. This makes the Next button and the Finish button available.

The Criteria field name and operation combo boxes all behave correctly when you click them, even though they are displayed incorrectly at first.

STATUS

Microsoft has confirmed that this is a problem in Microsoft Excel 2001 for Mac.

MORE INFORMATION

For more information about using queries with external data, follow these steps:
  1. On the Help menu, click Contents and Index, click Index, and then click Q.
  2. Scroll down until you locate query, and then click the arrow to the left to view a list of topics under the general topic.
  3. Click about using query to retrieve external data.
If you cannot find the information that you want, ask the Office Assistant.

Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbbug KB270104
©2002 Microsoft Corporation. All rights reserved.