View original (French)

Remove protection from an Excel workbook

Solved
Fox -  
 Meduse56 -
Hello,

Here is my problem: in Excel 2003, I protected a workbook with a password.
Today in Excel 2007, I would like to remove this password. We agree that I know the password and that I still have access to the workbook in question.

But my various attempts to remove the password in 2007 have been unsuccessful. I specifically went through the Review function, but nothing worked.

Thank you in advance
Configuration: Windows 7 / Safari 532.5

3 answers

  1.
    Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    Hi,

    Start by opening your file in Excel 2007, then click on the Office button/Save As/at the bottom of the dialog box click on Tools/General Options/in the password for reading you will notice dots representing your encrypted password, delete them and save
    -
    See you
    Mike-31

    A period of failure is a dream moment to sow the seeds of knowledge.
    44
    1. Fox
       
      Wonderful, it works!
      Thank you so much.
      0
    2. wwwill Posted messages 268 Status Member 18
       
      Hello Mike, I have the same problem. Except that the password for reading section is greyed out and inaccessible. I can only enter the password for modification.

      My main issue is that I can't insert a tab in my sheet like I used to. So I'm stuck updating the payroll file of a company with the new arrivals. Thank you for your help.
      0