Learning how to unprotect an Excel file is one of the most practical skills a spreadsheet user can develop, especially when you inherit a workbook from a former colleague, recover an old budget tracker, or need to edit a template that someone locked months ago. Excel offers several layers of protection, and each layer requires a slightly different unlocking approach. This guide walks you through every legitimate scenario so you can regain edit access without corrupting your data or losing formulas that took hours to build.

Microsoft Excel uses three distinct protection types that often get confused: file-open passwords, workbook structure protection, and worksheet (sheet) protection. A file-open password blocks the workbook from opening at all, while sheet protection only locks specific cells, ranges, or formatting options inside an already-open file. Workbook protection sits between them, preventing users from adding, deleting, hiding, or renaming sheets. Knowing which type you face determines the exact steps you need.

Most users searching for unlock methods are not trying to hack anything malicious. They are accountants opening archived files, analysts updating quarterly reports, or office managers reviving forgotten payroll templates. As long as you own the file or have permission from the owner, unprotecting it is a routine maintenance task built directly into Excel's Review and File tabs. The Review tab handles sheet and workbook locks, while File > Info > Protect Workbook handles open passwords.

If you remember the password, the process takes under thirty seconds. Click Review, choose Unprotect Sheet, type the password, and press OK. The lock icon disappears, formulas become editable, and conditional formatting rules can be modified again. The same logic applies to workbook structure protection, accessed from Review > Protect Workbook, where a single toggle restores your ability to insert, delete, or reorder tabs across the entire file.

When passwords are lost, the picture changes. Modern Excel files saved in the .xlsx format use AES-128 or AES-256 encryption for file-open passwords, which means brute-forcing them is impractical without specialized recovery software. Sheet and workbook structure protection, however, are much weaker. They were designed as accidental-edit guards, not security barriers, so legitimate XML editing techniques can remove them quickly when you own the file and have lost the key.

Throughout this guide we cover six pathways: removing a known sheet password, stripping workbook structure protection, eliminating a file-open password you remember, opening read-only files, handling Mark as Final restrictions, and using the XML method for forgotten sheet passwords on .xlsx workbooks. We also explain when to call IT instead of attempting recovery yourself, particularly for files protected with Information Rights Management or stored in restricted SharePoint libraries where corporate policy controls access.

By the end of this article you will know exactly which menu to click, which keyboard shortcut to use, and which third-party tools are worth considering when built-in options fall short. You will also understand the ethical and legal boundaries that separate routine file maintenance from unauthorized access, so you can confidently unprotect spreadsheets you legitimately own without crossing any lines.

The fastest way to unprotect an Excel file is the built-in Unprotect Sheet command, which lives on the Review tab of the ribbon. Open your workbook, click the locked worksheet tab at the bottom, then navigate to Review > Unprotect Sheet. If no password was set, the lock vanishes instantly. If a password was applied, a small dialog appears asking you to type it. Enter the password exactly as it was created, including capitalization, and press OK to release every protected cell on that sheet.

To remove workbook structure protection, the path is similar but slightly different. Go to Review > Protect Workbook, which acts as a toggle. If the button appears highlighted or pressed, structure protection is currently active. Clicking it once prompts for the password if one exists, or removes the lock immediately if it was set without a password. Once unlocked, you regain the ability to right-click sheet tabs to insert, delete, rename, move, copy, or change tab colors across the entire workbook.

For a file-open password that you remember, open the workbook normally by entering the password at the launch prompt. Once inside, click File > Info > Protect Workbook > Encrypt with Password. A dialog displays the current password as dots. Select all the dots, delete them, and click OK to leave the field blank. Save the workbook using Ctrl+S, and the next time anyone opens it, no password challenge will appear. The encryption is fully stripped.

When dealing with the Mark as Final designation, Excel shows a yellow Marked as Final bar at the top of the document area whenever you open the file. Simply click the Edit Anyway button on that bar, and the workbook becomes fully editable for the current session. To permanently remove the flag, go to File > Info > Protect Workbook > Mark as Final, which works as a toggle and clears the read-only intent from the file metadata so future users open it normally.

Read-only recommended files behave differently. When you open them, Excel asks whether you want to open the file as read-only. Click No to open in normal edit mode. To strip the read-only recommendation permanently, save the file with Save As, click Tools next to the Save button, choose General Options, uncheck the Read-only recommended box, and save. The file will no longer trigger the read-only prompt for any future user.

If your workbook came from email or a downloaded zip and opens in Protected View with a yellow security warning, that is not really protection in the password sense. It is a sandbox Excel uses for files from untrusted sources. Click the Enable Editing button on the yellow bar, and the file unlocks completely. This is one of the most common scenarios where users think they need to know how to add a filter in Excel but cannot because Protected View has disabled the ribbon.

Each of these methods assumes you own the file or have explicit permission to modify it. Corporate environments often layer additional Information Rights Management on top of standard Excel protection, where the access policy is enforced by Azure AD or a Rights Management Server rather than the file itself. In those cases, contact your IT administrator because no local Excel command can override organization-level rights policies.

The XML method is the gold-standard technique for removing forgotten worksheet protection on modern Excel files because it bypasses the password check entirely instead of trying to guess it. The technique works because .xlsx files are technically zip archives containing XML documents that describe the workbook structure. Sheet protection is recorded as a single XML attribute, and deleting that attribute tells Excel that the sheet was never protected in the first place. No password is ever decrypted; the protection flag simply disappears.

Start by closing the workbook in Excel and making a backup copy with a name like Original_Locked_Copy.xlsx. Right-click your working copy and rename the extension from .xlsx to .zip. Windows may warn you that changing the extension could make the file unusable; click Yes to proceed. Open the resulting zip file using Windows Explorer or a tool like 7-Zip. Inside, you will see folders named _rels, docProps, and xl. The worksheets you need to edit live in xl/worksheets.

Each sheet appears as sheet1.xml, sheet2.xml, and so on, numbered in the order they were created, not the order they appear in the tab bar. If you are unsure which file maps to which tab, open xl/workbook.xml first; it contains a list of sheet names and their internal sheet IDs. Identify the protected sheet, then extract its XML file, open it in Notepad, Notepad++, or Visual Studio Code, and search for the string sheetProtection. The full tag looks similar to a self-closing element with attributes for password hash, sheet, objects, and scenarios.

Select the entire sheetProtection tag from its opening less-than symbol through its closing slash and greater-than symbol, and delete it completely. Save the XML file. Then drag the modified XML back into the zip archive, replacing the original. Close the zip viewer, rename the file extension from .zip back to .xlsx, and open it in Excel. The sheet now opens fully editable. You can verify by clicking Review > Protect Sheet, which should show the protection dialog ready to accept a new password rather than offering to remove an existing one.

The same approach works for workbook structure protection. Instead of editing files in xl/worksheets, open xl/workbook.xml and look for a workbookProtection tag near the top of the document. Delete the entire tag, save, repackage the zip, and rename to .xlsx. When you reopen the file, you can right-click sheet tabs to add, delete, rename, hide, or rearrange them freely. The structural lock that prevented those operations is completely gone.

For macro-enabled workbooks with the .xlsm extension, the process is identical. The zip archive contains the same xl folder structure plus a vbaProject.bin file for macros, which you should not touch. Edit only the sheet#.xml or workbook.xml files. Macros continue to function normally after the XML edit because none of their code or references depend on the sheetProtection attribute. The unlocked workbook behaves exactly as the original would have if you had typed the correct password.

If you are uncomfortable editing XML manually, several free GUI tools automate the entire process. Excel Password Remover, Office Password Recovery Toolbox Lite, and the open-source script straxrip all wrap the same XML manipulation in a single click. They cannot crack file-open passwords because those involve real AES encryption, but they remove sheet and workbook structure locks in seconds without requiring any manual file extraction or text editing.

Once you have successfully unlocked a workbook, the next priority is deciding how to handle protection going forward. If the file contains formulas that should not be accidentally overwritten, reapply sheet protection but document the new password in a shared password manager like 1Password, Bitwarden, or your team's enterprise vault. Storing passwords in a sticky note or in the workbook itself defeats the purpose. A small investment in password hygiene saves hours of recovery work the next time someone needs the file.

For workbooks that genuinely need security, switch from sheet protection to file-open password encryption with AES-256. The setup lives at File > Info > Protect Workbook > Encrypt with Password. Choose a passphrase of at least 14 characters mixing letters, numbers, and symbols. Modern Excel uses strong key derivation, so a long passphrase resists brute-force attacks for decades. Combine this with a backup stored in OneDrive or SharePoint where Microsoft maintains version history and ransomware protection.

If your goal is sharing a workbook with multiple collaborators while still protecting sensitive sections, use range-level protection rather than locking the entire sheet. Select the cells you want others to edit, press Ctrl+1, navigate to the Protection tab, and uncheck Locked. Then enable sheet protection. Collaborators can edit the unlocked cells freely while protected formulas and reference data stay safe. This pattern works beautifully for input forms, budget submissions, and survey templates where each user fills only their assigned section. If you also need to freeze panes in Excel while keeping protection active, do that before enabling the lock.

For shared team workbooks stored on SharePoint or OneDrive, consider replacing local Excel protection with sensitivity labels from Microsoft Information Protection. Labels apply encryption, watermarks, and access policies centrally, and IT can revoke access remotely if an employee leaves or a device is lost. Local Excel passwords cannot be revoked once the file leaves your control, so a labeled file offers far stronger protection without the risk of permanent lockout from a forgotten password.

Always test your unlock workflow on a copy first. Excel files have grown more complex over the years, with embedded queries, Power Pivot models, dynamic arrays, and LAMBDA functions. While the XML protection-removal technique does not affect these features, any time you manipulate the underlying file structure there is a small risk of corruption. Working on a copy means a botched edit costs you nothing more than starting over from the original backup you wisely created before opening the zip archive.

Keep your Excel application fully updated through Microsoft 365 or the latest perpetual license. Older versions sometimes display unlocked sheets incorrectly or fail to honor the cleared protection flag until you reopen the file. Microsoft regularly patches edge cases around protection, especially after major Office updates. If a sheet still appears locked after your XML edits, close Excel completely, reopen the file, and check again. The display sometimes lags behind the underlying state.

Finally, document any protection changes in a project log or workbook comment. When the same workbook resurfaces in two years and someone else needs to update it, a clear note explaining when and why protection was removed prevents confusion. Treat unlocking as a maintenance event, not a one-off fix, and your team will have a much easier time managing the dozens of inherited workbooks that accumulate in any long-running organization.

Practical day-to-day tips can save you significant time when working with protected Excel files. Always check the file's status bar at the bottom of the Excel window first. If you see a small padlock icon or the words [Read-Only] in the title bar, that tells you exactly which kind of protection you are facing before you even start clicking through menus. This thirty-second observation often eliminates the need to try methods that do not apply to your specific situation.

Keyboard shortcuts speed up the unlock process considerably. Pressing Alt, R, P, S takes you straight to Unprotect Sheet on the Review ribbon in any English-language Excel installation. Alt, R, P, W opens the Protect Workbook dialog. Memorizing these shortcuts pays off when you regularly handle templates from multiple sources. Combine them with Ctrl+Shift+S for Save As, and you can backup-and-unlock a file in under fifteen seconds without touching the mouse at all.

When working with multiple protected sheets in the same workbook, write a short VBA macro to unlock them all at once if you know the password. The Sheets collection in VBA lets you loop through every worksheet and call Unprotect with the password as an argument. This saves enormous time on workbooks with twenty or thirty tabs, common in financial models. The macro can also report which sheets had protection and which did not, giving you an instant inventory of the file's lock state.

For files where the password is missing but the data is critical, consider whether you actually need to unlock the original or whether you can extract the data and rebuild. Press Ctrl+A, Ctrl+C on the locked sheet; in many cases Excel still copies the visible values even when editing is blocked. Paste into a fresh workbook with Paste Special > Values, and you have a clean copy without any protection inherited. Formulas are lost, but raw data is preserved and ready for new analysis.

Always rename your working copy with a clear suffix like _unlocked or _editable so you never confuse it with the original protected source. Many compliance frameworks require keeping the original locked version as evidence of the file's prior state. Mixing up the two during a busy work week is one of the most common causes of accidental data loss, so a strict naming convention pays dividends every time you revisit the project months later.

If you regularly inherit protected workbooks from a single source, ask whether the protection is actually serving its purpose. Sheet protection is meant to prevent accidental edits, but if the recipient routinely removes it anyway, the lock just adds friction without providing real security. A short conversation with the file owner about whether unprotected templates with clear input cells would work better often eliminates the recurring unlock task entirely.

Finally, build a personal reference document with your specific company's password conventions, recovery tools, and authorized procedures. The first time you unlock a workbook in any new role takes effort, but every subsequent unlock becomes routine when you have notes on which method worked, who to call for IRM-protected files, and where the licensed recovery software lives on your company network. A ten-minute reference doc today saves hours over the next two years.