Excel Err Msg: "Cannot Find File 'll'," Opening Multiple Files

 Last reviewed: September 12, 1996
Article ID: Q102674
The information in this article applies to:
  • Microsoft Excel for Windows, versions 4.0, 4.0a

In Microsoft Excel, you can open multiple files simultaneously by using the CTRL or SHIFT keys while selecting filenames in the Open dialog box. As you select files, the filenames are placed in the File Name box. The File Name box will recognize up to 246 characters. When the number of characters reaches 247, you will receive an error message similar to the following: 

   Sheet20.xl
   Cannot find this file.
Note that the filename is truncated.

When the number of characters is 248 or more, you will receive an error message similar to the following: 

   Cannot find 'll.'
Note that the filename in the error message may not resemble the name of the file that you were trying to open.

WORKAROUND

To work around either of these situations, open your files in smaller groups.

NOTE: In Microsoft Excel version 5.0, you cannot select more than 23 files in the Open dialog box. This behavior prevents you from receiving the error messages above.

For more information about opening multiple files in Microsoft Excel version 5.0, query on the following words in the Microsoft Knowledge Base: 

   maximum and selection and shift and 23

REFERENCES

"User's Guide 1," version 4.0, page 56

KBCategory: kberrmsg
KBSubcategory:

Additional reference words: 4.00 4.00a



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.