XL97: Add to List Button Is Dimmed in Advanced Find Dialog Box (157165)
The information in this article applies to:
- Microsoft Excel 97 for Windows
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:
- In Microsoft Excel 97, click Open on the File menu.
- Navigate to a folder that has several .xls files.
- Click Advanced.
- Click "Creation Date" in the Property list.
- Click "anytime between" in the Condition list.
- Type 8/1/96 in the Value box.
Notice that the Add to List button still appears dimmed.
- 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.
REFERENCES
For more information about finding files, click the Index tab in Microsoft
Excel 97 Help, type the following text
and then double-click the selected text to go to the "Use file properties
to locate files" topic.
| Modification Type: | Major | Last Reviewed: | 5/21/2001 |
|---|
| Keywords: | KB157165 |
|---|
|