Change or remove a workbook password

Important notice for users of Office 2003    To continue receiving security updates for Office, make sure you're running Office 2003 Service Pack 3 (SP3). The support for Office 2003 ends April 8, 2014. If you’re running Office 2003 after support ends, to receive all important security updates for Office, you need to upgrade to a later version such as Office 365 or Office 2013. For more information, see Support is ending for Office 2003.

ShowChange the password for viewing or editing a workbook file

  1. Open the workbook.
  2. On the File menu, click Save As.
  3. On the Tools menu, click General Options.
  4. In the Password to open or Password to modify box, double-click the asterisks.
  5. Type the new password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.), and then click OK.

 Important    Use strong passwords that combine uppercase and lowercase letters, numbers, and symbols. Weak passwords don't mix these elements. Strong password: Y6dh!et5. Weak password: House27. Passwords should be 8 or more characters in length. A pass phrase that uses 14 or more characters is better. For more information, see Help protect your personal information with strong passwords.It is critical that you remember your password. If you forget your password, Microsoft cannot retrieve it. Store the passwords that you write down in a secure place away from the information that they help protect.

  1. When prompted, retype the new password, and then click OK.
  2. Click Save.
  3. If prompted, click Yes to replace the existing workbook.

 Note   If you have protected a shared workbook (shared workbook: A workbook set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users.) with a password, you can't change the password without unsharing the workbook, which deletes the change history (change history: In a shared workbook, information that is maintained about changes made in past editing sessions. The information includes the name of the person who made each change, when the change was made, and what data was changed.).

ShowRemove the password for viewing or editing a workbook file

  1. Open the workbook.
  2. On the File menu, click Save As.
  3. On the Tools menu, click General Options.
  4. In the Password to open or Password to modify box (or in both boxes), double-click the asterisks and then press the DELETE key.
  5. Click OK, and then click Save.
  6. Click Yes to replace the existing workbook.

 
 
Applies to:
Excel 2003