Workbook passwords can be changed or removed by anyone who knows the current password.
Caution
Passwords in Excel for Mac
and Word for Mac
have a 15-character limit. You cannot open a workbook or document that has been password protected in the Windows-based version of Excel
or Word
if the password is longer than fifteen characters. If you want to open the file in Office for Mac, ask the Windows-based author to adjust the password length.
Do any of the following:
 | Change a workbook password |
Caution
When you create a password for a workbook, write down the password and keep it in a secure place. If you lose the password, you can't open or gain access to the password-protected workbook.
-
Open the workbook that you want to change the password for.
-
On the Review tab, under Protection, click Passwords.
-
In the Password to open box or Password to modify box, select all contents.
-
Type the new password, and then click OK.
-
In the Confirm Password dialog box, type the password again, and then click OK.
-
Click Save 
.
| Remove a workbook password |
-
Open the workbook that you want to remove the password from.
-
On the Review tab, under Protection, click Passwords.
-
Select all contents in the Password to open box or the Password to modify box, and then press DELETE.
-
Click Save .
