Forum Discussion
How to change the password of a workbook in Excel for Microsoft 365
Hello,
I want to use a stronger password for an (entire) Excel file (i.e., a workbook) than the one I installed a year ago.
I am aware of these articles:
https://support.microsoft.com/en-us/office/protection-and-security-in-excel-be0b34db-8cb6-44dd-a673-0b3e3475ac2d
https://support.microsoft.com/en-us/office/protect-an-excel-file-7359d4ae-7213-4ac2-b058-f75e9311b599
I need to remove the first password for the workbook, and then enter the new password. For some reason, it doesn't work as outlined in the article.
Any idea how I can do this?
Thank you!
4 Replies
- NikolinoDEPlatinum Contributor
Before you deal with password protection, you have to know in which levels and what type of password protection you already use.
In the upper link you will find more informations about password protection, maybe it will help you.
- FSP_HCopper Contributor
Thank you for your message (a few weeks ago).
I figured out how I set the password for my Excel file or my Excel workbook (I assume this is the same for now): I went to File, Info, Protect Workbook, Encrypt with Password, and then I entered the Password, and then re-entered it.
This website explains exactly what I did:
https://support.microsoft.com/en-us/office/protect-an-excel-file-7359d4ae-7213-4ac2-b058-f75e9311b599?ui=en-US&rs=en-US&ad=US
Now I would like to change that password to make my password stronger.
Do I first have to (somehow) undo or remove the password, and then set a new password?
Or is there another way to change the password, perhaps with an even higher security setting?
Thank you for your input,
FSP_H
- NikolinoDEPlatinum Contributor
Here are some links that will help you better understand the password settings in Excel.
Changing a password on a password protected Excel
How do I unlock a Workbook, Worksheet, VBA Project, without a password?
Video: Protect an Excel file
Video: Restrict changes to files
Protection and security in Excel
My answers are voluntary and without guarantee!
Hope this will help you 🙂.