Microsoft KB Archive/151104

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

Article ID: 151104

Article Last Modified on 8/17/2005

-

APPLIES TO


 * 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

where 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.