XL5: Find File Subdirectory Search Limitations

 Last reviewed: September 12, 1996
Article ID: Q105098
The information in this article applies to:

- Microsoft Excel for Windows, version 5.0

SUMMARY

When you use Find File to search for files in Microsoft Excel version 5.0, you may receive the following error message: 

   The path you specified contains too many subdirectories. Delete one
   or more directories or clear the Include Subdirectories check box.
This error is displayed if the search process scans more than 200 subdirectories or a path of subdirectories is 15 levels deep.

When you receive the error message, you will be unable to search any more subdirectories for files: the list of found files will only contain files from those directories that were successfully searched.

This is by design.

WORKAROUND

If the search path you specify is too large, do either of the following:

  • Clear the Include Subdirectories check box in the Search dialog box.

    -or-

  • Refine your search by using a more specific location (for example use "C:\EXCEL\FILES" instead of "C:\").

MORE INFORMATION

The most common reason this error occurs is when you search your entire hard drive for files.

KBCategory: kbusage
KBSubcategory:

Additional reference words: 5.00



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: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.