XL98: Unable to Delete or Hide Sheet1 (184500)


The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition
This article was previously published under Q184500

SYMPTOMS

In Microsoft Excel 98, when you open a workbook that you have created in Microsoft Excel version 5.0, the following behavior may occur:

  • A worksheet that is named Sheet1 is inserted into the workbook. -and-

  • You cannot delete or hide Sheet1 unless you first insert another visible sheet.

CAUSE

This behavior may occur if the workbook that you have created in Microsoft Excel version 5.0 contains only module sheets.

WORKAROUND

To work around this behavior, insert a visible sheet in the workbook.

You cannot initially delete or hide the worksheet that is inserted into the workbook when you open the workbook in Microsoft Excel 98. One or more visible sheets must exist in a workbook. In Microsoft Excel 98, you cannot unhide module sheets that you have inserted in workbook that you have created in an earlier version of Microsoft Excel. If you insert another visible sheet, you can delete or hide Sheet1.

STATUS

This behavior is by design of Microsoft Excel 98.

MORE INFORMATION

If you encounter this behavior and you try to delete the inserted Sheet1, you receive the following error message:
A workbook must contain at least one visible worksheet.

To hide, delete, or move the selected sheet(s), you must first insert a new sheet or unhide a sheet that is already hidden.
In Microsoft Excel 98, you cannot insert new module sheets or unhide module sheets that you have inserted into a workbook that you have created in an earlier version of Microsoft Excel. Therefore, you must retain the extra worksheet. If you insert another visible sheet into the workbook (such as a chart sheet or a Microsoft Excel 5.0 dialog sheet), you can then delete or hide the worksheet that Microsoft Excel has inserted.

REFERENCES

For more information about opening workbooks created in earlier versions of Microsoft Excel, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Excel Help, type the

worksheets, overview

and then click Show Topics. Select the "About workbooks and worksheets" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant.
Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbprb KB184500
©2002 Microsoft Corporation. All rights reserved.