Forgot Excel Sheet Password? Safe Recovery Options

How-to basics · Updated November 18, 2026

If you forgot the password for a protected Excel worksheet, Excel has no built-in command to reveal or reset it: in Microsoft 365 for Windows, open the sheet and choose Review > Unprotect Sheet, then enter the password if you know it. If it is your file and you do not have the password, first look for an unprotected copy or ask the workbook’s owner; for a standard .xlsx file, an advanced option is to remove the worksheet-protection setting from a duplicate of the file, as described below.

What Excel sheet protection does

Worksheet protection is mainly a way to prevent accidental changes. A workbook creator can lock cells, protect a sheet, and allow selected actions such as sorting or filtering. The protection prompt asks for a password when someone tries to change those settings. It does not encrypt the worksheet’s contents or make the file private in the way a password required to open a workbook does.

This distinction matters: someone who can open a sheet-protected workbook can generally see its data, and the protection is not a dependable security boundary for confidential information. Do not use sheet protection as a substitute for controlling access to a sensitive file. Use appropriate file permissions or encryption instead.

  • Worksheet protection: limits editing or certain actions on a particular sheet.
  • Workbook structure protection: restricts changes such as adding, deleting, moving, or renaming sheets.
  • Password to open: encrypts the file; Excel requires the password before showing its contents.
  • Password to modify: can restrict editing while allowing a person to open a read-only copy.

The words “protected Excel file” can refer to any of these. The recovery choices are different, especially for a password that encrypts the file itself.

Try the supported recovery options first

Microsoft Excel does not provide a forgotten-sheet-password recovery feature or a way to display the original password. If you are authorized to edit the workbook, start with these low-risk options:

  1. Ask the person who protected the sheet. The workbook’s creator, colleague, or administrator may have the password or an editable master copy. If the file belongs to an organization, follow its normal access process.
  2. Find another copy. Check email attachments, shared folders, project archives, and backups. Search by workbook name and date; a previous version may have been saved before protection was applied.
  3. Check version history. For a workbook stored in OneDrive or SharePoint, use the file’s version history to inspect or restore an earlier version. In Excel for Windows, you can often open the file’s menu from the title bar or use File > Info and look for version history, depending on how the file is stored and your account.
  4. Look for recovery copies. Excel’s AutoRecover or unsaved-file recovery may help after a crash or accidental closure, but it is not a password-recovery feature. It is useful only if a relevant version was actually saved or recovered.
  5. Ask whether the sheet can be edited another way. The owner may be able to unlock only the required cells or make the specific change, without removing protection from the entire sheet.

On Windows, the normal command for a known password is Review > Unprotect Sheet. If the sheet is protected, Excel asks for the password. On Mac, use the Review tab and choose Unprotect Sheet; the exact ribbon arrangement can vary by Excel release. Excel for the web has fewer workbook-management features, so open the file in the desktop app if the relevant command is unavailable.

For your own .xlsx file: remove sheet protection from a copy

If you own the workbook or have clear permission to change it, and the file is a regular .xlsx, you can remove the worksheet-protection setting without recovering the password. This is an advanced workaround, not a Microsoft password-reset feature. It changes the file package, so keep the original untouched and use a copy. Do not use it to bypass someone else’s access controls.

  1. Make a backup. Close the workbook, create a duplicate, and work only on that duplicate. Confirm the file ends in .xlsx. This method does not apply in the same way to the older .xls format or the binary .xlsb format.
  2. Show file extensions and make a ZIP copy. In File Explorer, enable View > Show > File name extensions if needed. Rename the duplicate’s extension from .xlsx to .zip, then open or extract the ZIP using Windows’ built-in archive support or a reputable archive utility. If Windows warns about changing the extension, confirm only after checking that you have the backup.
  3. Identify the correct worksheet file. Inside the extracted folder, open xl/workbook.xml and xl/_rels/workbook.xml.rels with a plain-text or XML editor. These files link a visible sheet name to a worksheet file, usually named something like xl/worksheets/sheet1.xml. Do not assume that “Sheet1” always maps to sheet1.xml; workbooks can have different mappings.
  4. Remove the protection element. In the XML file for the intended worksheet, locate the sheetProtection element and delete that element only. It is often written as a single tag beginning <sheetProtection. Do not delete other XML content or edit a different worksheet by mistake.
  5. Repackage and check the result. Create a ZIP archive with the workbook package’s contents at the archive root, including [Content_Types].xml and the xl folder; do not put an extra parent folder around them. Rename the resulting ZIP back to .xlsx, open it in Excel, and verify the intended sheet and its contents. Save a new working copy if it opens correctly.

Excel workbook files in the .xlsx format are packages containing XML parts, and worksheet protection is represented in a worksheet’s XML. Removing that setting stops Excel from enforcing the sheet’s edit restrictions; it does not reveal the forgotten password. XML structure can vary, so a malformed edit or incorrectly repackaged file may fail to open. If the file is important, have an IT professional make the change or work from a further duplicate.

This does not decrypt a workbook that asks for a password before opening. It also does not necessarily remove workbook-structure protection, and it can invalidate a digital signature or affect other package features. Files managed by organizational policies, labels, or rights-management systems may have additional restrictions. Keep the original and use an authorized recovery route if anything unexpected happens.

When you only need the information

You may not need to unprotect the sheet to recover its contents. If Excel lets you select cells, try copying the required range into a new workbook or exporting a permitted copy. Whether selection and copying work depends on the protection options chosen by the person who set up the sheet. Some protected sheets allow users to select unlocked cells but not locked cells; others allow broader selection.

Copying visible values is not always a complete substitute for the original. It may omit formulas, formatting, validation rules, comments, named ranges, or relationships to other sheets. If the goal is to make a business change, obtain an editable authorized copy rather than rebuilding a workbook from displayed values. If the data is sensitive, do not upload it to a website just to extract or unlock it.

Sheet protection versus an encrypted workbook

A password prompt before the workbook opens is a different problem from a prompt after choosing Unprotect Sheet. Modern Excel encryption for a password-to-open file protects the contents; changing a worksheet XML file is not a way around it because the package cannot be read normally without decryption. You need the correct password, an authorized backup, or help from whoever manages the file. Microsoft cannot retrieve a forgotten password for you.

A password to modify may instead allow you to open the workbook read-only. If Excel offers that choice and you only need to inspect the data, open the read-only copy and do not overwrite the original. Remember that read-only access is not the same as permission to change or distribute the file.

Recovery tools, online services, and safety

Websites and utilities may claim to unlock any Excel password. Treat broad promises with caution. A tool that asks you to upload a workbook could expose customer, payroll, health, or business information. Some services may also make unsupported changes, fail on encrypted files, or return a damaged workbook. Do not provide a confidential workbook to a third party unless your organization has approved that service and its data-handling terms.

  • Prefer a version-history restore, an owner-provided copy, or an approved internal support route.
  • Keep an unchanged backup before using any file-editing utility or XML method.
  • Do not run unknown scripts or enable macros in a workbook from an untrusted source.
  • For a password-to-open prompt, avoid tools claiming that ordinary sheet-protection removal will decrypt the file.

Prevent the same problem next time

When you protect a sheet, store the password somewhere approved and accessible to the people responsible for the workbook. A password manager or controlled team vault is safer than a note in the workbook itself. Document which sheets are protected and who can authorize changes. For shared files, keep a controlled unprotected master copy if that fits your organization’s rules, and use version history so earlier versions can be recovered.

Also protect only what needs protection. In Excel for Windows, use Review > Protect Sheet to set sheet permissions, and choose which actions users may perform. Protection is intended to reduce accidental edits, so make clear to collaborators which cells they should change and how to request an update. For confidential content, restrict access to the file itself rather than relying on a worksheet password.

Frequently Asked Questions

Can Excel tell me a forgotten sheet password?
No. Excel has no built-in command to show or reset a forgotten worksheet password. Find the password, obtain an authorized earlier copy, or use the XML workaround only on a workbook you own or are allowed to modify.

Can I remove sheet protection without the password?
For an authorized, standard .xlsx file, removing its worksheet-protection element from a duplicate can stop that sheet’s edit restriction. This is not password recovery, does not decrypt a password-to-open workbook, and is not suitable for every Excel file format.

Will removing protection delete my worksheet data?
It should not delete worksheet data when the correct protection element alone is removed, but incorrect XML edits or repackaging can damage the file. Preserve the original, work on a duplicate, and verify the result in Excel.

Can I unlock a protected sheet in Excel for the web?
If you know the password, open the workbook in the desktop app if the web version does not offer the needed protection command. The web app does not provide a way to recover a forgotten password. Ask the owner or use an authorized prior version.

Does a worksheet password protect confidential information?
No. Worksheet protection is designed mainly to limit editing, not to encrypt the contents. Use file encryption and access controls for confidential workbooks, and follow your organization’s security requirements.

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.