Quick answer:

  1. 1️⃣ Lost the sheet or workbook-structure password? Excel Password Recovery removes the lock from your .xlsx file in one run.
  2. 2️⃣ Forgotten the password to open the file? Excel Password Recovery searches for it and shows it to you.
  3. 3️⃣ Know the password? To remove password from XLSX, use Review > Unprotect Sheet or File > Info > Protect Workbook > Encrypt with Password.
Excel Password Recovery Screenshot.
️ Eugene - CEO at SoftOrbits, Candidate of Technical Sciences, has more than 16 years of expertise in software development, photo and multimedia applications, enhancing and transforming digital images and videos.
📅 Last updated on:  2026-11-20

Use these methods only on files you own or have the owner's permission to open.

What you will learn
Apply in 10 min Saves 1 hMedium

How to remove Excel workbook password and sheet locks with Excel Password Recovery

TL;DR

Excel Password Recovery removes sheet and workbook-structure locks from your .xlsx file without the password. If the file is encrypted, the same run searches for the password to open it and shows you the result.

Rebuilding a really complex workbook just because its lock is stuck is, in one tutorial author's words, "a headache to set this up from scratch." Removing only the lock leaves your formulas and charts as they were.

Add one or more workbooks and click Start. The program removes sheet and structure protection first. You get an editable copy. If the file is encrypted, the program searches for the password instead. Enter the password it finds at Excel's prompt.
If you've unlocked several workbooks, you can merge two Excel spreadsheets into one.

 Excel Password Recovery message that 12 files were unlocked and saved to the Editable folder..

Excel Password Recovery
Excel Password RecoveryRemove sheet and workbook locks from your own .xlsx files and search for forgotten open passwords in one batch.

Which Excel password do you have, and which methods fit it?

TL;DR

A sheet or workbook-structure lock is a flag you can remove. A password to open encrypts the file. If you've lost that password, you need to find it. Check when Excel asks for it.

  • Excel asks for a password before the file opens: the whole file is encrypted. It's no longer a ZIP archive you can edit.
  • Excel offers read-only access or asks for a password to edit: you have a password to modify. Excel Off The Grid explains why this isn't secure: you can open the file read-only and save a copy under a new name.
  • The file opens, but you can't change cells or sheet tabs: the file's XML contains a sheet or workbook-structure lock.

256-bit
AES key that Microsoft documents as the default for an .xlsx file encrypted with a password to open in Office 2016
Source

MethodLocks it handlesNeeds the passwordWhere the file goes
Excel Password RecoverySheet and workbook-structure protection; searches for a password to openNoStays on the drive
Excel menusEvery lock aboveYesStays on the drive
ZIP and XML editSheet and workbook-structure protectionNoStays on the drive
Online removerMostly sheet protectionNo for sheets, yes to openGoes to a website or runs in a browser tab

How do you remove a password from Excel when you know it?

TL;DR

Anyone who knows the current password can remove it, as Microsoft Support documents. Use Unprotect Sheet for a sheet, Protect Workbook for the structure, and Encrypt with Password for the password to open.

One user still remembered the password and wanted it gone only because it blocked Autosave and Share.

  • Sheet protection: open Review, click Unprotect Sheet and enter the password.
  • Workbook structure: on the Review tab, click Protect Workbook. Enter the password to turn protection off.
  • Password to open: to delete Excel password protection, go to File > Info > Protect Workbook > Encrypt with Password and clear the dots in the box. Click OK and save.
  • Password to modify: under File > Save As > Tools > General Options, clear the Password to modify field and save.

The open and modify passwords have separate boxes. Clear the one you need and save before closing, or Excel will ask again.

Can you unprotect Excel sheet without password by editing the file?

TL;DR

Yes. In an .xlsx file, deleting the XML element for a sheet or workbook-structure lock removes that lock. This edit won't remove a password to open.

An .xlsx file is a ZIP archive of XML parts. The tutorial on unprotecting Excel sheets points out that its sheet edit removes only sheet protection.

One tutorial author locked his own sheet so nobody could mess with this data, and later had to open it again himself. He prefers a way that needs no random third party tool, and for a plain sheet lock that is realistic.

A bad XML edit can corrupt the file or cost you data.

Unprotect a sheet by hand with a ZIP tool

Copy the workbook before touching it

Edit a copy, just for safety. To make sure we don't lose anything, keep a spare on a password-protected USB drive.

Rename the copy from .xlsx to .zip

If you have an old .xls file, save it as .xlsx first; .xls isn't an archive. Turn on file name extensions in File Explorer, change the copy's extension from .xlsx to .zip and confirm the warning.

Open the archive and find the sheet file

Open the .zip in an archive tool. 7-Zip is the most popular one, but you might have something else installed. As IONOS describes, go to xl/worksheets and open sheet1.xml in a text editor. Each worksheet has its own file; repeat the edit for each locked sheet. For a structure lock, look for workbookProtection in xl/workbook.xml instead.

Delete the sheetProtection element

Find sheetProtection. If you'll need the lock again, copy this specific tag and take note of this location. It goes back in the exact same location. Delete the whole element and save the file inside the archive when prompted to update it.

Rename it back and open it in Excel

Change .zip back to .xlsx and open the copy in Excel. If Excel reports a content problem and offers to restore the file, accept and check the data. You can compare two Excel sheets, one from the original and one from the edited copy.

Excel Password Recovery Excel Password Recovery

Excel Password Recovery removes the protection from your own Excel sheet or workbook, or recovers a forgotten password. It reads both modern XLSX and older XLS files.

Can a password to open an Excel file be removed, or only found?

TL;DR

Only found. A password to open is the encryption key for the file, so there is no setting to delete. An answer on Microsoft's Q&A site says a forgotten password on a fully encrypted file has no recovery route and no bypass from Microsoft.

One user had tried every password they knew and had gone back to older versions of this document, and nothing worked. Before starting a search, check OneDrive or SharePoint version history and older backups for a copy saved before the password was set.

Microsoft Support describes removal only if you know the password. VBA macros can't open an encrypted file either, and as ExcelDemy notes, the ZIP edit fails on a file protected with Encrypt with Password.

100,000
rounds of hashing per password guess by default in Office 2016. Deriving the encryption key makes each guess slow.
Source

Excel Password Recovery runs a dictionary-based Excel password recovery search against your file. It tries words and common variations and shows you the password if it finds a match. To remove it, open the file with that password and clear it under Encrypt with Password. A familiar word can fall quickly, while for a strong password the forum advice is that you have to wait sometime.

Is it safe to use an online Excel password remover?

TL;DR

Keep confidential workbooks off these sites. The operator receives your upload, and you can't verify a claim that your file stays in the browser tab.

Free online Excel password remover sites mostly handle sheet locks. None can bypass a password to open. One how-to guide advises against using these services for any file containing sensitive or personal data. Use Excel's menus, the ZIP edit or a program on your drive. Keep the opened file in a password-protected folder.

Excel Password Recovery Excel Password Recovery
Remove a password from your own Excel file: sheet and workbook locks, the open password, and what to do when you forgot it. Steps for Windows.
Excel Password Recovery Screenshot.


🙋Frequently Asked Questions

For a sheet or structure lock, edit the file or use Excel Password Recovery. For a password to open, check OneDrive or SharePoint version history before searching for the password.

Choose Review > Unprotect Sheet or, for a structure lock, Review > Protect Workbook. Enter the password. Without it, use the ZIP edit or a desktop program for a sheet lock.

If the workbook opens with locked cells, remove sheet protection. If Excel asks for a password before opening, you need the encryption password.

At the read-only prompt, enter the password to modify, or open the file read-only and use Save As to give the editable copy a new name.

Open it with the current password, clear the box under Encrypt with Password and save.

You probably closed the file without saving. Reopen it with the password, clear the box and press Ctrl+S before closing. If the prompt persists, check the password to modify in General Options.

Sources