Microsoft KB Archive/288612

= XL2002: Encryption Scheme Error: This Workbook Cannot Be Opened =

Article ID: 288612

Article Last Modified on 5/21/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q288612



SYMPTOMS
When you open a workbook, the following error message appears:

This workbook has been password protected with an encryption scheme not available in this region. This workbook cannot be opened.



CAUSE
This problem can occur when all of the following are true:


 * The regional language (locale) in Microsoft Windows is set to French when you set your workbook security encryption type to Weak Encryption (XOR) and typed a password.
 * The workbook is shared to allow changes by more than one user at the same time.
 * The regional language (locale) in Microsoft Windows is set to another language, such as U.S. English, when you attempt to open the workbook in Excel 2002.



WORKAROUND
To share a workbook protected by an encrypted password between the French language and other languages, follow these steps:  Remove sharing from the workbook.

 On the Tools menu, click Share Workbook. Click the Editing tab. Click to clear the Allow changes by more than one user at the same time check box. Click OK.

NOTE: If the workbook is opened by any other users when you remove sharing, the other users will not be able to save their latest changes to the workbook. Change the encryption type to Office 97/2000 Compatible.  On the Tools menu, click Options.</li> Click the Security tab. Click Advanced. Change the encryption type to Office 97/2000 Compatible. Click OK.</li> In the Password to Open box, type your password and click OK. When prompted to reenter your password, type it again, and then click OK.</li></ol> </li> Share the workbook again.</li></ol>

<div class="moreinformation_section">

MORE INFORMATION
XOR encryption is the weakest encryption available. It is the default option for the French locale. In the French local, when XOR encryption is used, you can share a workbook. However, the default encryption for Excel 2002 running on other locales, such as U.S. English, is Office 97/2000 Compatible. In this latter case, if the XOR weak encrytion scheme is selected, the option to share workbooks is unavailable.

Additional query words: XL2002 prb revision stream

Keywords: kberrmsg kbpending kbprb KB288612

-

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

© Microsoft Corporation. All rights reserved.