Microsoft KB Archive/813972

= Error message when you try to edit multiple cells in a protected worksheet by using a single password in Excel: &quot;Some of the cells you are trying to change are password protected&quot; =

Article ID: 813972

Article Last Modified on 1/23/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003

-



SYMPTOMS
When you try to edit cells in a Microsoft Office Excel 2003 workbook or in a Microsoft Office Excel 2007 workbook, you may receive the following error message:

Some of the cells you are trying to change are password protected, but no one password will allow access to all of the cells. Click OK, and then try editing one cell at a time.

Note In Excel 2007, you can use the following procedure: To determine the unique number that is associated with the message that you receive, press CTRL+SHIFT+I. The following number appears in the lower-right corner of this message:

101151



CAUSE
This problem may occur if the following conditions are true:
 * The worksheet is protected with a password.
 * You try to simultaneously edit multiple cells.
 * The multiple cells are protected with a single password.



WORKAROUND
To work around this problem, follow these steps:
 * 1) Double-click any one of the cells in the range of cells that you want to edit.
 * 2) When Excel prompts you for the password, type your password, and then click OK.
 * 3) Continue to perform an operation that involves the editing of multiple password-protected cells.

Notice that you do not receive the error message, and that your operation is completed successfully.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
The error message is misleading because one password actually can permit access to all the cells. However, you must type the password for at least one of the cells before you can perform a multiple-cell edit.

Excel 2007

 * 1) In Excel 2007, type any text into cells A1:A2.
 * 2) Select cell B1.
 * 3) Click the Review tab.
 * 4) In the Changes group, click Allow Users to Edit Ranges.
 * 5) Click New, and then type =$B$1 under Refers to cells.
 * 6) Under Range password, type test.
 * 7) Click OK, confirm the password, and then click OK again.
 * 8) Click New, and then type =$B$2 under Refers to cells.
 * 9) Under Range password, type test.
 * 10) Click OK, confirm the password, and then click OK again.
 * 11) Click Protect Sheet, and then click OK.
 * 12) Select cells A1:A2.
 * 13) Click the Home tab.
 * 14) In the Clipboard group, click Copy.
 * 15) Select B1.
 * 16) In the Clipboard group, click Paste.

Excel 2003

 * 1) In Excel 2003, type any text into cells A1:A2.
 * 2) Select cell B1.
 * 3) On the Tools menu, point to Protection, and then click Allow Users to Edit Ranges.
 * 4) Click New, and then type =$B$1 under Refers to cells.
 * 5) Under Range password, type test.
 * 6) Click OK, confirm the password, and then click OK again.
 * 7) Click New, and then type =$B$2 under Refers to cells.
 * 8) Under Range password, type test.
 * 9) Click OK, confirm the password, and then click OK again.
 * 10) Click Protect Sheet, and then click OK.
 * 11) Select cells A1:A2.
 * 12) On the Edit menu, click Copy.
 * 13) Select B1.
 * 14) On the Edit menu, click Paste.

In both examples, you receive the error message that is mentioned in the &quot;Symptoms&quot; section.

Additional query words: XL2003 XL2007 OfficeErrorMessages 10037 cells ranges

Keywords: kbpasswords kberrmsg kbprb KB813972

-

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

© Microsoft Corporation. All rights reserved.