Excel: Unbound Closed Files Remain Listed in Workbooks

ID: Q81859

The information in this article applies to:

Microsoft Excel for Windows, version 4.0
Microsoft Excel for the Macintosh, version 4.0

SUMMARY

In Microsoft Excel version 4.0, an unbound document that is listed in a workbook will not be removed from the workbook document list, even if you close the workbook without saving changes.

MORE INFORMATION

Example

From the File menu, choose New. Select Worksheet, and choose OK.

From the File menu, choose New. Select Workbook and choose OK.

Choose the ADD button.

Select a worksheet from list of open documents and choose OK.

Unbind the document by clicking on the icon to the right of the filename.

Choose the Options button. Enter a new filename and choose OK.

Activate the document by double-clicking the document name.

From the File menu, choose Close, and choose No when prompted to save the changes.

The workbook should now be the visible document and the worksheet name is still listed in the workbook. When you attempt to activate this document or rename the document, you will receive the "Can't Find <filename>" alert message. Note that if you did not rename the document as shown in step 6, Microsoft Excel will open a new document using the name listed in the workbook.

To remove the document from the workbook, click the document name in the workbook list and choose the Remove button. Excel will display the "Can't Find <filename>" alert message. Choose OK and the document will be removed from the workbook document list.

Additional query words:


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 24, 1999