Excel Undo Encrypt with Password? How to Remove It

How-to basics · Updated November 22, 2026

Yes, you can undo Excel’s “Encrypt with Password” feature, but only if you know the password. If you’ve forgotten it, there is no built-in Excel command to recover or remove it—you’ll need third-party software or a manual workaround. This article explains exactly how to remove encryption when you have the password, what to do if you don’t, and how to avoid common pitfalls.

What Does “Encrypt with Password” Actually Do?

When you use File > Info > Protect Workbook > Encrypt with Password in Excel, the file is encrypted using AES-256 (in modern versions). This isn’t just a lock that prevents opening—it scrambles the entire file content. Without the correct password, the file cannot be opened at all, even with hex editors or recovery tools. This is different from “Mark as Final” or “Protect Sheet,” which only restrict editing. The encryption is applied at the file level, so it affects every sheet, macro, and data point in the workbook.

How to Remove Encryption When You Know the Password

If you have the password, removal takes less than a minute:

  1. Open the encrypted workbook by entering the password when prompted.
  2. Go to File > Info.
  3. Click Protect Workbook and select Encrypt with Password.
  4. In the dialog box, delete the existing password (leave the field blank).
  5. Click OK, then save the file (Ctrl+S or Cmd+S on Mac).

That’s it. The next time you open the file, no password will be requested. This works identically in Excel for Microsoft 365, Excel 2021, and older versions back to Excel 2007. On Excel for the web, you cannot remove encryption because the feature isn’t available—you must use the desktop app.

What If You Forgot the Password?

If you don’t remember the password, Excel offers no built-in recovery. Microsoft explicitly states that passwords are not recoverable. Your options are:

  • Try common passwords—birthdays, names, or simple patterns you often use.
  • Check password managers—if you saved it there, you’re safe.
  • Use a third-party recovery tool—some can brute-force or use dictionary attacks. These are not official and may be costly or risky.
  • Restore an earlier version—if you have a backup or a cloud version history (e.g., OneDrive or SharePoint), you might retrieve an unencrypted copy from before you applied the password.

Important: There is no “backdoor” in Excel. Editing the XML inside the file (e.g., by unzipping and removing the fileSharing tag) does not work for password encryption—that only works for workbook structure protection, not file encryption.

Why Can’t You Just “Undo” It with Ctrl+Z?

Many users expect that since applying a password is an action, Ctrl+Z (undo) might reverse it. That’s a misconception. Encryption is saved as part of the file’s metadata and is written to disk when you save. The undo history only covers changes within the current session, and once you close the file, the encryption is permanent until you change it. Even if you immediately press Ctrl+Z after applying the password, Excel may not revert the change because it’s a file-level property, not an edit. The only reliable way is the manual removal steps above.

Choosing a Strong but Memorable Password

Since recovery is nearly impossible, choose a password that’s strong yet recoverable. Use a passphrase (e.g., “BlueElephant#2024!”) and store it in a password manager. Avoid using the same password for multiple files. If you’re encrypting sensitive data, consider using a dedicated encryption tool like 7-Zip or BitLocker for folders, which may offer more flexible recovery options (like recovery keys). But for Excel-specific encryption, your password is your only key.

Common Problems and Fixes

  • Password works but file still asks? You might have saved a copy elsewhere. Check the file path and ensure you saved after removing the password.
  • Can’t find “Encrypt with Password”? In Excel for the web, it’s not available. Use the desktop version. On Mac, go to Review > Protect Workbook > Encrypt with Password (the menu differs slightly).
  • File is corrupted after removing password? This is rare, but always keep a backup before making changes. If corruption occurs, try opening with “Open and Repair” (File > Open > select file > arrow next to Open > Open and Repair).
  • Third-party tool says “password not found”? Some tools have limited success with AES-256. If the password is long and random, recovery may take years. Consider restoring from backup.

Alternatives to Password Encryption

If you need to share files securely but want easier recovery, consider:

  • Protect Sheet/Workbook—prevents editing but doesn’t encrypt; password can be removed via VBA or by copying data.
  • Digital signatures—verify authenticity but don’t hide content.
  • Cloud sharing permissions—use OneDrive/SharePoint to control access without a password.
  • Compressed folder with password—using 7-Zip or WinRAR, which may offer recovery options.

Each has trade-offs. For sensitive data, encryption is best, but always keep a recovery plan.

Frequently Asked Questions

Can I remove a password I forgot by editing the file’s XML?

No. For file encryption, the password is used to derive an encryption key, and the file content is scrambled. Removing the XML tags that store the password won’t decrypt the data—the content is unreadable without the key. This trick only works for sheet or workbook protection, which is a different, weaker feature.

Does Excel have a master password or backdoor?

No. Microsoft does not provide any backdoor for file encryption. That would defeat the purpose. Law enforcement and forensic specialists also cannot bypass it without brute force. If you lose the password, you lose access permanently.

Is there a way to recover a password using a dictionary attack?

Third-party tools can attempt dictionary or brute-force attacks, but success depends on password complexity. A simple word like “password” might be cracked in minutes; a random 16-character string could take centuries. These tools are not free (some have trial limitations) and may be flagged by antivirus software. Always download from reputable sources.

Does removing the password affect the file’s content or formatting?

No. Removing encryption only changes the file’s security settings. All data, formulas, formatting, and macros remain intact. The process is non-destructive as long as you save properly.

Can I remove encryption on Excel for Mac the same way?

Yes, the steps are nearly identical. On Mac, go to Review > Protect Workbook > Encrypt with Password, delete the password, and save. The ribbon path differs slightly, but the function is the same. Excel for the web does not support this feature at all.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.