Either way, you can modify or remove Excel workbook passwords in a few simple steps. This is how to do it.
How to Change or Remove the Password of a Password-Protected Excel Workbook
To change the password of a password-protected Excel file, follow these steps:
Open the password-protected Excel file you want to change the password for. Enter the old password and hit OK. Navigate to the File menu on the top-left and go to Info. Click on Protect Workbook dropdown and click on Encrypt with Password. Enter the new password and re-enter it to confirm. Hit OK.
With the above steps, you can password-protect your Excel file with a new password that you can share again.
RELATED: How to Password Protect an Excel File
If you want to remove the password, you have to follow steps one through four. Next, you need to leave the password field blank in step five rather than entering a password. Removing the password does not require confirmation.
Share Your File by Changing Excel Workbook Password
So, that’s how you can change or remove the password for Excel files. When you do, be sure to save the workbook. If not, this change won’t take effect, and you’ll end up sharing the workbook with the same old password, which will cause problems for both you and the recipient.
Whenever you password-protect an Excel VBA document, make sure you write it down in a few different locations. Even though you can recover an Excel VBA password, it won’t be easy. Take extra care with this.
