Changing a password on a password protected Excel

[Leccy_Barbara]

How do I do this? the help section only says how to set oe

[#2 · Accepted solution]

@Leccy_Barbara 

To change a password on a password-protected Excel file in Excel 365 (Microsoft 365 Apps), you will need to follow these steps:

1. Open the Password-Protected Excel File:
• Locate and open the Excel file that is protected with a password.
2. Enter the Current Password:
• When you open the file, Excel will prompt you to enter the current password to unlock the workbook. Enter the password and click "OK."
3. Access the Password Change Option:
• Go to the "File" tab in the top-left corner of the Excel window.
4. Navigate to Protect Workbook:
• In the "Info" section, you should see a button labeled "Protect Workbook." Click on the drop-down arrow next to it.
5. Choose "Encrypt with Password":
• From the drop-down menu, select "Encrypt with Password."
6. Remove the Current Password:
• In the "Encrypt Document" dialog box, you will see a password field with dots or asterisks representing the current password. Clear the contents of this password field to remove the existing password. Leave it blank.
7. Save the File:
• Click "OK" to confirm that you want to remove the password. Now, the password protection for the Excel file is removed.
8. Resave the Excel File:
• Remember to save the file after removing the password. You can use "Ctrl + S" or go to the "File" tab and choose "Save."

Your Excel file should no longer be password-protected, and you can open it without entering a password in the future. 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. The text and steps were created with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

[#3]

Thanks for that - I had just managed to work that out as it happens - but I appreciate you taking the time to reply. It also confirmed that the way I did it was correct:)