Change or remove workbook passwords | Microsoft Support Clicking Unprotect Sheet automatically removes the password from the sheet To add a new password, click Protect Sheet or Protect Workbook, type and confirm the new password, and then click OK
Changing a password on a password protected Excel | Microsoft Community Hub Keep in mind that removing the password means anyone with access to the file can open it without needing a password If you want to protect the file again, you can set a new password following the same steps as mentioned above
Require a password to open or modify a workbook | Microsoft Support Open the sheet or workbook that you want to protect On the Review tab, click Protect Sheet or Protect Workbook In the Password box, type a password, and in the Verify box, type the password again Choose any other protection options you want and click OK Click Save
How to Change or Remove a Workbook Password in Excel If you feel the current password for your Excel workbook isn't secure enough, or if you think the password is unnecessary, you can change or completely remove it However, the steps are a bit different between Windows and Mac
How to unlock Excel workbook and worksheet when password is lost For a protected sheet, use Review > Unprotect Sheet and enter the password if prompted For a protected workbook structure, use Review > Protect Workbook (which acts as Unprotect when protection is on) and enter the password If the password is forgotten, it cannot be recovered by Excel
Changing a Workbook Password (Microsoft Excel) Excel allows you to apply protection to your workbooks If you want to later change the passwords associated with that protection, all you need to do is to follow the steps outlined in this tip
I am not able to change the password for workbook Open the workbook that is currently password-protected Go to the Review tab and click Protect Workbook (or Protect Sheet, if applicable) Enter the current password to unprotect the workbook To set a new password: Click Protect Workbook again Enter and confirm the new password in the dialog box Click OK and save the workbook