Knowledge Base

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

Article ID: 151104

Article Last Modified on 8/17/2005

Microsoft Excel 95 Standard Edition
Microsoft Windows NT 3.51 Service Pack 5

This article was previously published under Q151104

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

Additional query words: XL7

Keywords: KB151104