Home     Blog

Microsoft Excel Password Recovery

Microsoft Excel documents can utilize three passwords:

  • Password to open
  • Password to modify
  • Protect sheet or Protect workbook

Password to Open

The Password to open requires a user to enter a password to view the document.

When the user sets a Password to open, the entire Microsoft Excel document is encrypted with the RC4 stream cipher.

Password to Modify

The Password to modify requires a user to enter a password to make changes to the document.

When a user sets a Password to modify, the password is stored inside the Microsoft Excel document. The password can be viewed or changed with a hex editor.

Protect Sheet or Protect workbook

microsoft excel password recovery Microsoft Excel Password RecoveryThe Protect sheet or Protect workbook password requires the user to enter a password to no longer protect the worksheet or the workbook.

When a user sets a Protect sheet or Protect workbook password, the 32-bit password hash is stored in the document. The password hash can be viewed or changed with a hex editor.

Applying Passwords in Microsoft Excel

To apply a Password to open or modify to a Microsoft Excel document, click click <File>, <Save As>, <Tools>, <General Options>. Then, select the desired encryption algorithm and the key length to use with that algorithm.

The supported algorithms are:

  • Weak Encryption (XOR)
  • Office 97/2000 Compatible
  • RC4, Microsoft Base Cryptographic Provider v1.0
  • RC4, Microsoft Base DSS and Diffie-Hellman Cryptographic Provider
  • RC4, Microsoft DH SChannel Cryptographic Provider
  • RC4, Microsoft Enhanced Cryptographic Provider v1.0
  • RC4, Microsoft Enhanced DSS and Diffie-Hellman Cryptographic Provider
  • RC4, Microsoft Enhanced RSA and AES Cryptographic Provider (Prototype)
  • RC4, Microsoft RSA SChannel Cryptographic Provider
  • RC4, Microsoft Strong Cryptographic Provider

The default is “Office 97/2000 Compatible.” However, even Microsoft states that this is not recommended!

To apply a Protect sheet or Protect workbook password to a Microsoft Excel document, click <Tools>, <Protection>.

Microsoft Excel Password Recovery

It is possible simply to edit the Password to modify with a hex editor. It is also possible to edit the hash of the Protect sheet or Protect workbook password.

The Password to open can be attacked with a dictionary attack or a brute force attack.

Several programs, with widely varying capabilities, are available to help recover a lost Microsoft Excel password:

Additional Reading on Excel Password Recovery

VN:F [1.9.17_1161]
Rating: 0.0/10 (0 votes cast)
Follow Will.Spencer on

Leave a Reply

Related Posts

  • How Does Microsoft Word Password Recovery Work?

    Microsoft Word documents can utilize three passwords: Password to open Password to modify Protect document password   Password to Open   The Password to open requires a user to enter a password to view the document.   When the user sets a Password to open, the entire Microsoft Word document is encrypted with the RC4 [...]...


  • Microsoft PowerPoint Password Recovery

    Microsoft PowerPoint documents can utilize two passwords: Password to open Password to modify Password to open The Password to open requires a user to enter a password to view the document. When the user sets a Password to open, the entire Microsoft PowerPoint document is encrypted with the RC4 stream cipher. Password to modify The [...]...


  • How to Create Excel Macros

    A macro is a template of commands and functions which can be used to facilitate automation of tasks you repeatedly do in Microsoft Excel. You can specify if a macro is available only to a certain workbook or to all Microsoft Excel files. Set the Security Level to Medium or Low Open an Microsoft Excel [...]...


  • How to Import Data in Excel

    Importing data to MS Excel is the process of transferring data from other database sources and converting it into .xls format. This process eliminates the need to manually enter every item into a new Excel worksheet. Importing data therefore saves the user a lot of time and reduces human error. The source data is called [...]...


  • Hotmail Password Recovery

    Hotmail is a free (i.e. advertiser supported) web based e-mail system that the Microsoft Corporation provides. Hotmail Password Recovery Hotmail password recovery methods include: Resetting the Hotmail password online Recovering the stored Hotmail password from the web browser Resetting the Hotmail Password Online The easiest way to recover a Hotmail password is to go to [...]...