XL7: Error Message "There is no disk in the drive..."

Last reviewed: September 13, 1996
Article ID: Q151104

The information in this article applies to:

Microsoft Excel for Windows 95, version 7.0
Microsoft Windows NT, version 3.51

SUMMARY

When you open a Microsoft Excel version 7.0 file in Microsoft Windows NT you may receive the following error message:

   There is no disk in the drive. Please insert a disk into
   drive <drive letter>

where <drive letter> is a logical CD-ROM drive. If you click Retry or Ignore several times the workbook will eventually open.

CAUSE

This error message is caused by a reference to a file or library that is no longer valid.

WORKAROUND

To work around this behavior, either have a CD-ROM in the drive or remove the references to the missing workbooks. To remove the references, do the following:

Select a Visual Basic module sheet.
On the Tools menu, click References.
Click to clear any references that have the word "MISSING:" before the name of the reference, for example:
```
      MISSING: Summary.xls
```

KBCategory: kbusage kberrmsg
KBSubcategory:
Additional reference words: 7.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 13, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.