excel file password protection

Copper Contributor

Hello. I used Information menu to protect my Excel file with a passowrd and saved my file. when I open the file I am not asked to input a password.  Do you know what is wrong?

 

4 Replies

@ridha92 

 

I use Tools>General Options in the "Save As" dialog box to input password, it's very helpful.

mpalacpac_0-1625151416696.png

 

@ridha92  there are many options under that menu.  which one did you use?  there are some that protect the sheet or the workbook structure.  I think the one you want to use is this one: Encrypt with password.

mtarler_0-1625151556684.png

 

@mpalacpac 

 

Thanks for  your answer.

In fact I tried this option but it works only for xlsx file.

For csv format , the Password fields are not accessible.

 

So my conclusion is that the protection password options is available only for xls(x) format and not csv.

that is correct. csv does not support password protection. you could zip the csv file and put a password on the zip so they need the password to open the zip file to then access the csv.