Excel: Passwords not Recognized After Switching Systems

 Last reviewed: November 10, 1994
Article ID: Q89650
The information in this article applies to:
  • Microsoft Excel for the Macintosh, versions 2.2, 3.0, 4.0

Summary:

Microsoft Excel may not accept a password with special characters if the file containing the password is opened under a different Macintosh operating system. Codes for some characters created with the OPTION key differ between System 6.0x and System 7.0x. Therefore, passwords containing special OPTION characters created under System 6.0x may not be recognized under System 7.0x, and vice versa. The only workaround is to change or remove the password while operating the Macintosh with the system that was in use when the file was created.

More Information:

Microsoft Excel versions 3.0 and 4.0 allow for three different passwords in a worksheet: Protection Password and Write Reservation Password when you choose Save As from the File menu, and Protect Document on the Options menu. Excel version 2.2 allows two passwords: Password when you choose Save As from the File menu and Protect Document on the Options menu. If any of these passwords are assigned with an OPTION key character, Excel may not accept the password when the file is opened under a different system.

Workaround

To change the password:

  1. Restart the Macintosh using the system the file was created under.

  2. Launch Microsoft Excel, and open the file.

  3. Change (or delete) the password containing the special characters.

  4. Save the file, replacing the existing file.

Reference(s):

"Microsoft Excel User's Guide 1," version 4.0, pages 84-90

"Microsoft Excel User's Guide" for the Macintosh, version 3.0, pages 556-562

"Microsoft Excel Reference" for the Macintosh, version 2.2, pages 275-276, 550-552

KBCategory: kbusage
KBSubcategory:

Additional reference words: 2.2 2.20 3.0 3.00 4.0 4.00 keycaps

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 10, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.