Microsoft KB Archive/157165

= XL97: Add to List Button Is Dimmed in Advanced Find Dialog Box =

Article ID: 157165

Article Last Modified on 5/21/2001

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q157165





SYMPTOMS
The Add to List button in the Advanced Find dialog box appears dimmed when you use a numeric, date, or time property, and specify a Condition between two values, dates, or times.



WORKAROUND
When you specify a criteria that falls between two values, use the word "and" to separate the two values, dates, or times.

For example, to find all files created between August 1, 1996 and August 15, 1996, follow these steps:
 * 1) In Microsoft Excel 97, click Open on the File menu.
 * 2) Navigate to a folder that has several .xls files.
 * 3) Click Advanced.
 * 4) Click "Creation Date" in the Property list.
 * 5) Click "anytime between" in the Condition list.
 * 6) Type 8/1/96 in the Value box.

Notice that the Add to List button still appears dimmed.
 * 1) Modify the text in the Value box to read 8/1/96 and 8/15/96

The Add to List button is now available.



MORE INFORMATION
The Advanced Find search tool in Microsoft Excel allows you to create more complex searches. You can use it to find files based on advanced criteria such as the date a file was created or last printed, its size in bytes, number of pages, number of characters within a file name, author name, strings of text within a file, and so forth.

