XL2000: Cannot Enter Text into Cells in Protected Worksheet (215934)
The information in this article applies to:
This article was previously published under Q215934 SYMPTOMS
In Microsoft Excel, if you attempt to type text in a cell, the text disappears when you press ENTER, but when you type a number, the number is entered as expected.
CAUSE
This behavior can occur if all of the following conditions are true:
- Two or more sheets in your workbook are grouped.
-and- - The sheets in your workbook that are grouped are also protected.
-and- - Individual cells in the sheets are unprotected.
-and- - The unprotected cells are set to wrap text.
WORKAROUND
To work around this issue, first ungroup the worksheets, and then type text in the cells that you want. After you type the text in the cells, you can group the worksheets and the text remains in the cells.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. MORE INFORMATION
To group worksheets in an Excel workbook, press and hold down the CTRL key while you click the sheet tabs.
| Modification Type: | Major | Last Reviewed: | 9/27/2003 |
|---|
| Keywords: | kbbug kbpending KB215934 |
|---|
|