Find an Excel Password in a Protected File? Safe Options

You usually cannot find or reveal a password from inside a protected Excel file: Excel does not display a forgotten password. If the file is encrypted with a password to open it, you need the password or an accessible backup; if only a sheet or workbook structure is protected, the file may still open and the person who set the protection can remove it.

Why Excel protection has different meanings

People use “protected Excel file” to describe several different situations, and the right next step depends on which one you have. A password prompt before the workbook opens is not the same as a message that appears when you try to edit a cell.

Password to open: The workbook is encrypted. Excel asks for the password before showing its contents. Without the correct password or a usable unencrypted copy, Excel has no built-in way to reveal or reset it.
Worksheet protection: The workbook opens, but certain cells or actions on a sheet are restricted. This is mainly intended to prevent accidental changes, not to encrypt the sheet’s contents.
Workbook structure protection: The file opens, but actions such as adding, deleting, moving, hiding, or renaming sheets may be blocked.
Password to modify or read-only recommendation: A prompt may let you open a copy as read-only. This is different from a password required to decrypt and open the file.
Organizational access control: A work or school file may be restricted by a sensitivity label or rights-management policy. That is controlled by the organization’s account and permissions, not necessarily by an Excel password.

These distinctions matter. A password that protects a worksheet is not a key that unlocks an encrypted file, and changing a sheet’s protection will not resolve a password prompt that appears before the workbook opens.

How to identify the kind of password prompt

Start with what you can see. If Excel asks for a password immediately after you select the file and before any worksheet appears, it is likely a password-to-open prompt. If the workbook opens normally but you cannot type into particular cells, or a command is unavailable, look for sheet or structure protection instead.

In Excel for Microsoft 365 on Windows, a workbook encrypted with a password is also associated with File > Info > Protect Workbook > Encrypt with Password. If you can open the file and have permission to inspect its settings, this area can help confirm whether encryption is enabled. Do not expect it to show the existing password; it does not.

A separate sign is the exact wording of a prompt. “The cell or chart you are trying to change is on a protected sheet” points toward worksheet protection. A request to enter a password before the workbook’s contents are visible points toward encryption. If the message mentions an organization, permissions, or a sensitivity label, contact the file owner or IT support rather than treating it as a forgotten Excel password.

Legitimate ways to recover access

If you are authorized to use the workbook, work through sources that may contain the password or an earlier accessible copy. Excel itself cannot reconstruct a forgotten password, but the person or system that supplied the file may be able to help.

Ask the creator or current owner. They may remember the password, have recorded it, or be able to provide an unlocked copy. For a company file, ask the owner or IT team and follow the organization’s access process.
Check your own password manager and records. Search for the workbook name, project, client, or sender. Look in relevant emails, secure notes, handover documents, and team-approved storage. Avoid putting a confidential password in an ordinary message if your organization requires a safer method.
Find the original source. The sender may still have the password or an unprotected version. Check whether the attachment was also shared through a document-management system or another approved channel.
Look for a prior version or backup. OneDrive or SharePoint version history, a company backup, or a local backup may contain an earlier copy. Restore or download a copy rather than overwriting the only current file.
Check whether the issue is editing rather than opening. If the workbook opens, ask the owner for the sheet or structure password, or for an authorized editable copy. The password may be different for different sheets or files.

Try only passwords you have a reasonable basis to use, such as a password supplied for that project. Random guessing is unlikely to help, can waste time, and may violate workplace rules or the file owner’s expectations.

If the workbook opens but a sheet is protected

With the correct password and authorization, open the workbook in Excel for Microsoft 365 on Windows, select the protected sheet, and choose Review > Unprotect Sheet. Enter the password when prompted. If the owner has supplied an editable version, save it as a separate file or follow the owner’s instructions so the original remains intact.

Workbook structure protection is separate. It restricts changes to the workbook’s sheets rather than locking particular cells. In desktop Excel, use the protection control on the Review tab, commonly shown as Protect Workbook, and enter the password if Excel requests it. The exact control shown can depend on the workbook’s current state and Excel’s interface.

Once you have permission and have removed a protection setting, save the change. If the workbook contains formulas, macros, external links, or business-critical data, preserve a copy before editing. In Excel for Mac, protection controls are also on the Review tab, though the ribbon layout can differ. Excel for the web has fewer desktop features and may not provide the same controls; use the desktop app or ask the owner if a protection command is unavailable.

What to do when the password is required to open the file

A password-to-open workbook is encrypted, so the situation is more serious than a locked editing control. If you do not know the password, Excel for Microsoft 365 does not offer a password-recovery button, administrator override, or feature that displays the forgotten password. Reinstalling Office or renaming the file will not reveal it.

For a work or school file, contact its owner or IT administrator. If the file is yours, search for the original email, a password manager entry, secure project notes, or a backup made before encryption was applied. A prior version may help only if it is genuinely an accessible, unencrypted version; version history does not automatically remove encryption from the current file.

Excel for the web cannot open a workbook encrypted with a password. Use the desktop Excel app and the correct password for that type of file. If the document is governed by an organization’s sensitivity label or rights-management policy, sign in with an authorized account and contact the administrator if access is denied.

Backups, versions, and recovery copies

Look for a copy before considering any unfamiliar recovery service. If the workbook is stored in OneDrive or SharePoint, open its version history through the file’s available menu and inspect earlier versions. The interface can vary by location and account. Download or restore a version only after checking that it is the right file and that restoring it will not discard other people’s changes.

For files stored on a computer or company server, check the organization’s backup and retention process, Windows File History if it was configured, or another backup system you already use. A recovered copy may be older than the latest workbook, so compare its date and contents before relying on it. Keep the protected original unchanged until you know the recovered file is complete.

AutoRecover is intended to help restore unsaved work after an interruption; it is not a password-recovery system. It may help with lost edits in some circumstances, but it should not be expected to decrypt a file or remove a password.

Why online unlockers and password-cracking claims are risky

Websites and utilities may claim to unlock any Excel file, but uploading a workbook can expose payroll, customer, financial, health, or confidential business data to an unknown service. You may not know where a copy is stored, who can access it, or how long it is retained. Some downloads advertised as recovery tools may also contain unwanted or malicious software.

There is another important distinction: a tool that removes a sheet-editing restriction is not necessarily recovering the password that encrypted a workbook. Claims that one method works for every Excel file overlook differences in protection type, file format, and encryption. Do not use a bypass method on a file you do not own or lack permission to access. For sensitive business files, ask IT or your security team before using any third-party software.

How to prevent the same problem next time

For files you control, store passwords in an approved password manager and label the entry with the exact workbook or project name. If other people need access, document how authorized users can request it and keep an unencrypted backup only where policy permits. A password sent separately from the file is generally safer than placing both in the same message, but follow your organization’s secure-sharing rules.

Use worksheet protection for its intended purpose: limiting accidental edits to selected cells. Do not treat it as a way to conceal sensitive information. Use file encryption and approved access controls when confidentiality is the goal, and remember that losing the encryption password can make the workbook inaccessible. Before adding protection to an important file, confirm that an authorized person can open it and that the password is recorded securely.

Frequently Asked Questions

Can I see the password stored in an Excel file?

No. Excel does not provide a command to display a forgotten password. If the workbook opens, you can inspect or change protection settings only with the required authorization and password; an encrypted file cannot be opened without its password or another accessible copy.

Can Microsoft reset a forgotten Excel password?

Excel does not include a reset service that decrypts a password-protected workbook. Microsoft support or an organization’s IT team may help locate backups, confirm account permissions, or contact the file owner, but they cannot simply reveal a password that is not available.

Is a protected worksheet encrypted?

Worksheet protection is primarily an editing restriction, not confidentiality encryption. It helps prevent changes to locked cells or sheet features, but it should not be relied on to keep the workbook’s contents secret. Use file encryption and appropriate access controls for sensitive data.

Can I open an encrypted Excel workbook in a browser?

No. Excel for the web cannot open a workbook encrypted with a password. Use desktop Excel with the correct password, or ask the owner for an authorized copy or another approved way to access the information.

Will changing the file extension remove the password?

No. Renaming a workbook does not remove encryption or recover a password, and changing extensions can make files harder to identify or open. Keep the original file and use the owner, an approved backup, or your organization’s support process.

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.