'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Recover a Forgotten Password for a Protected Excel Worksheet
Question details
The user needs to regain access to or unprotect an Excel worksheet after losing or forgetting the assigned password.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to edit, modify, or view a locked Excel worksheet without the required password.
- Observed behavior
- The worksheet remains locked, and there is no built-in official tool or feature in Microsoft Office to recover the forgotten password.
Ensure you have authorized permission to access the file's contents, and create a backup copy of the current locked file before attempting any version restoration.
Restore to a Previous File Version
Since there is no official password recovery tool, restoring an older version of the file from before the password was applied is the safest workaround.
Microsoft explicitly states that lost passwords for protected worksheets cannot be recovered. Attempting to use unauthorized password-cracking tools can compromise your computer's security.
If you have Windows File History or system backups enabled, you can often revert the file to an unprotected state.
Open Windows File Explorer and navigate to the folder where your protected Excel worksheet is saved.
Right-click the Excel file and select 'Restore previous versions' from the context menu.
Look through the list of available versions for a date and time before you added the password protection. Select the older version and click 'Restore'.
Check Alternate Backups or Contact the Owner
If you do not have Windows File History enabled, explore other backup locations or reach out to the original creator of the file.
A Secure and Lightweight Alternative to Microsoft Excel
If you are looking for a reliable, cost-effective solution for your documents, WPS Office is a highly compatible, feature-rich alternative to Microsoft Office. It handles your spreadsheets securely with built-in encryption, offering a familiar interface with zero learning curve.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install the Application: Run the installer and follow the quick on-screen instructions to set up WPS Office on your computer.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets, click 'Open', and select your existing Excel files to continue your work without missing a beat.
Frequently Asked Questions
Will Microsoft Support help me unlock my protected Excel file?
No. For security and privacy reasons, Microsoft Support cannot assist in recovering or bypassing forgotten passwords for any Office documents.
Are third-party password cracking tools safe to use?
It is strongly advised against using unauthorized password-cracking software. These tools often contain malware, risk data corruption, and violate standard security protocols.
Can I remove the password if I suddenly remember it?
Yes. If you remember the password, open the Excel file, go to the 'Review' tab, click 'Unprotect Sheet', enter your password, and save the document.
