Microsoft KB Archive/172858

= OFF97: Error Activating Password-Protected Workbook Object =

Article ID: 172858

Article Last Modified on 1/20/2007

-

APPLIES TO


 * Microsoft Office 97 Standard Edition
 * Microsoft Word 97 Standard Edition
 * Microsoft Excel 97 Standard Edition
 * Microsoft PowerPoint 97 Standard Edition

-



This article was previously published under Q172858



SYMPTOMS
When you attempt to activate a Microsoft Excel 97 workbook object that is embedded in a Microsoft Word 97 document or a Microsoft PowerPoint 97 presentation, you may receive one of the following error messages:

Microsoft Word

Word cannot edit the Microsoft Excel Worksheet.

Microsoft PowerPoint

There isn't enough memory available to read Worksheet.



CAUSE
This problem occurs if the following conditions are true:


 * The workbook object is protected with a password (point to Protection on the Tools menu, click Protect Workbook, and then enter a password in the Password box).

-and-
 * Your computer is using French regional settings.

Specifically, the problem occurs because you cannot activate a Microsoft Excel 97 workbook object that is protected with a password when your computer is using French regional settings.



RESOLUTION
To resolve this problem, switch the regional settings on the computer to English before you attempt to activate the workbook object again. To do this, follow these steps:


 * 1) On the Start menu, point to Settings, and then click Control Panel.
 * 2) Double-click Regional Settings. Click the Regional Settings tab.
 * 3) In the list of regional settings, click "English (United States)" or another English setting. Then, click OK.
 * 4) When you are prompted to restart the computer, do so.

After the computer is restarted, start Microsoft Word 97 or Microsoft PowerPoint 97, open the document that contains the workbook object, and then activate the workbook object.

Once the workbook object is activated correctly, unprotect the workbook object. If you protect the workbook object again, make sure you do not apply a password to the workbook.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: OFF97 XL97 WD97 PP97 france belgium switzerland luxembourg standard rc4 encrypt decrypt

Keywords: kbbug kberrmsg kbinterop KB172858

-

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

© Microsoft Corporation. All rights reserved.