Change or remove workbook passwords
Workbook passwords can be changed or removed by anyone who knows the current password.
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
Remove a workbook password