The owner of the MS Excel document can set a password for making changes to the document. Such a password can protect certain cells or entire sheets from editing. Typically, users protect in this way those work files that other employees have access to. But what should you do if you forgot such a password from your file?
For technical reasons, we have no way to restore the original password, but we have the opportunity to remove such protection from the document. Having received an unprotected document, you can re-protect it with a password if necessary, only this time try not to lose it!
Our site unlocks Excel documents in just a couple of seconds, and it is completely free for our visitors. We do not ask you to register on the site or any personal data. Just go to the MS Excel Password Recovery page, upload your document, and after a few seconds, you can download the already unlocked file.
Our program can process MS Excel documents version 2007 and higher (*.xlsx files). Unfortunately, we cannot remove the protection of old-format Excel worksheets (*.xls files).
How to Unlock an Excel Sheet Yourself
Sometimes users cannot afford to upload their files to extraneous services. This may be dictated by the security policy of the company or the presence of confidential data in the table. We perfectly understand you, and therefore we share with you a simple instruction on how to independently unprotect an Excel document.
A modern MS Office document is, in fact, an ordinary Zip archive (only documents protected by a password for opening are an exception). You can remove protection from an Excel document simply by making small changes to the contents of the archive.
Assume that your file is called foo.xlsx. Follow the instructions below.
-
Rename your foo.xlsx file to foo.zip. For verification, simply open this file in any archiver such as WinZip or WinRar; if the file opens and you see a list of files and folders, then we are on the right track.
-
Unzip the contents of the archive into the foo folder.
-
Go to the xl -> worksheets folder.
-
Open sheetXX.xml files one after another in any text editor (Windows Notepad is suitable).
-
In the contents of each file, find the XML tag sheetProtection, and delete it entirely; that is, delete a piece of text starting with <sheetProtection and ending with />
-
When all the sheets have been edited, go to the root of the foo folder and save all its contents to the foo.zip archive.
- Now rename foo.zip to foo.xlsx.
If everything was done correctly, then the Excel file should open, the protection of its sheets should be removed.
Legal Notes
Please note that we respect copyright and process applications for password recovery and removal only from the owner of this file. Before using the service, you must accept our Terms and Conditions.
See Also
Copyright © 2017-2024 LostMyPass.com