Forum Discussion

ridha92's avatar
ridha92
Copper Contributor
Jul 01, 2021

excel file password protection

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?

 

excel

4 Replies

  • mtarler's avatar
    mtarler
    Silver Contributor
    Jul 01, 2021

    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.

     

  • mpalacpac's avatar
    mpalacpac
    Copper Contributor
    Jul 01, 2021

    ridha92 

     

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

     

    • ridha92's avatar
      ridha92
      Copper Contributor
      Jul 01, 2021

      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.

      • mtarler's avatar
        mtarler
        Silver Contributor
        Jul 01, 2021
        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.

Resources