XL98: Advanced Filter Criteria Range or List Range Box Empty

• Microsoft Excel 98 Macintosh Edition

SYMPTOMS

In Microsoft Excel, when you use the Advanced Filter to filter a list on a worksheet, and the criteria range is located on another worksheet, the Criteria Range box is empty when you use the Advanced Filter again on the worksheet that contains the list. Additionally, the List Range box is empty when you use the Advanced Filter again on the worksheet that contains the criteria range.

CAUSE

This behavior occurs because the criteria range that you use to filter your list is defined on the worksheet that it is contained in. Similarly, the list range only appears in the Advanced Filter dialog box if it is contained on the current sheet.

If you use a criteria range that is contained on the same worksheet as the list, and you select a cell in the list before you use the Advanced Filter, both the list range and the criteria range are displayed in the Advanced Filter dialog box.

WORKAROUND

To automatically display the criteria range in the Advanced Filter dialog box, when the criteria range is contained on a different worksheet but in the same workbook as your list, follow these steps:

1. Select the worksheet that contains the criteria range.



2. On the Insert menu, point to Name, and then click Define.



3. If you have previously used this range as a criteria range, delete the local name "SheetName!criteria."



4. In the Names In Workbook box, type Criteria. Click the Refers To Box, and select the criteria range on the worksheet. Click OK.

1. Select the list range.



2. On the Insert menu, point to Name, and then click Define. In the Names In Workbook box, type Database and click OK.

Additional query words: XL98

Keywords : kbdta xllist
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbbug