Microsoft KB Archive/218980

= XL97: Protected Worksheet Allows You to Paste Data into Cells =

Article ID: 218980

Article Last Modified on 4/21/2001

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q218980





SYMPTOMS
When you protect a worksheet in Microsoft Excel, you are still allowed to paste data into certain protected cells.



CAUSE
This problem occurs when you enable the Locked property on a merged cell and you then protect the worksheet.



WORKAROUND
Do not merge cells in a protected worksheet. An alternative to using merged cells to represent labels is to use a text box.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem no longer occurs in Microsoft Excel 2000.



MORE INFORMATION
You can merge a range of cells into one cell using the Merge Cells command. When you protect a worksheet containing merged cells, you can still paste data into the merged cell using Paste on the Edit menu. However, you still cannot edit the merged cell.

Additional query words: XL97

Keywords: kbbug kbpending KB218980

-

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

© Microsoft Corporation. All rights reserved.