XL97: Add to List Button Dimmed in Advanced Find

 Last reviewed: January 15, 1998
Article ID: Q157165
The information in this article applies to:
  • Microsoft Excel 97 for Windows
  • Microsoft Office 97 for Windows

SYMPTOMS

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

CAUSE

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

The following example finds all files created between August 1, 1996 and August 15, 1996.

  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. Choose "Creation Date" in the Property box.

  5. Choose "anytime between..." in the Condition box.

  6. Type "8/1/96" in the Value box. Notice the Add to List button still appears dimmed.

  7. Click in the Value box and type "8/1/96 and 8/15/96"

  8. the Add to List button is now available.

MORE INFORMATION

The Advanced Find search tool 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, last printed date, size in bytes, number of pages, number of characters within a filename, 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 

   files, finding
and then double-click the selected text to go to the "Use file properties to locate files" topic.

Additional query words: XL97 8.00 gray disabled unavailable
Keywords : offosb xlui kbtool
Version : WINDOWS:97
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: January 15, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.