How to Restore, Unlock Encrypted Excel File Without Password

Tracy King updated on Jul 02, 2019 to File Recovery | How-to Articles

Summary

Don’t worry if you accidentally deleted or lost important Excel files with password encryption. This page will tell you how to effectively recover deleted, lost Excel file and unlock/remove password protection from encrypted Excel in Windows 10/8/7. If you need a simple way to decrypt and restore Excel without a password, follow the offered methods here and get your problem solved right here.

Can I recover lost Excel and decrypt it without password

"Hi there, do you know how to restore lost Excel file and decrypt it without a password?
I lost an important Excel file which was encrypted by password-protection. I couldn't find it in the recycle bin and no tracks were found in my PC by searching the file name.

Somebody told me that there is a chance to restore my lost encrypted Excel file. But how can I decrypt an Excel file without a password? I don't even remember the password. If anyone of you has a way to help me restore and unlock Excel file without a password, please let me know. Thanks."

Losing Excel files or Word documents in Windows system is no longer a new problem. But losing encrypted Excel and unlocking password may cause a serious result to you. If you are looking for a reliable way to restore and unlock Excel file without a password, just relax and follow offered methods here in this page to restore your Excel without a password now.

Step 1. Restore deleted or lost password-protected Excel files

If you accidentally deleted or lost an important Excel file with a password, don't worry.

You may first try to find and restore it from the Recycle Bin.
If nothing was found, try to search and find it in your PC by searching the Excel file name.

If you still find nothing in your PC, relax! Professional file recovery freeware - EaseUS Data Recovery Wizard Free Edition will effectively help to scan and find your lost Excel file in Windows 10/8/7.

Just download it for free, install and apply it to restore your lost or deleted Excel file with below simple guidelines now:

Simple steps for Excel file recovery are as follows:

Step 1. Specify a location

Run EaseUS Data Recovery Software, firstly, you're asked to choose a location to start. Choose the drive X: or perhaps a specific folder on Desktop or somewhere else, and then click "Scan".

select the excel file location

Step 2. Scan data

During the scan, you'll see more and more data showing up very quickly in the "Deleted files" result. That's part of what the software has found and displayed.

scan excel files

Step 3. Preview and recover

To quickly find the Excel files in the massive data in the scan results, click on the "Filter" on the top area and choose "Documents". Or, search .xls or .xlsx in the Search box. Select the desired files and click "Recover".

select excel files and recover


Step 2. Unlock and restore Excel file without password

After restoring lost Excel file, you may now follow any one of the offered methods to unlock and remove the password protection from the found Excel file without a password now:

Method 1. Unlock/unprotect Excel file and software

Step 1. Create a new folder and drag password-protected excel into the folder;
Step 2. Open the folder and go to Organize > Click Folder and search options;
Step 3. Tab View and scroll down to uncheck Hide extensions for known file types > Click Apply;
Step 4. Now the Excel extension is .xlsx and change it to .zip > Click Yes when it asks if you want to change a file name extension;
Step 5. Open the zip file with an unzip program, click xl folder > Worksheets > Sheet1.xml and open it with Notepad;
Step 6. Search Sheet protection password="**" and delete the password in the quotes > Save the Notepad and click Yes;
Step 7. Change the extension from .zip to .xlsx and hit Yes;
Step 8. Open the Excel sheet and go to Review and click Unprotect Sheet;
Step 9. Now you can edit your Excel file and unlock it to reusable again.

Method 2. Decrypt protected Excel without a password by VBA code

Step 1. Open the Excel file, and press Alt + F11 to open VBA window.
Step 2. Click on Insert, select Module.

Decrypt Excel without password.

Step 3. On the General window enter the VBA code.

Unlock Excel file without password.

Step 4. Click on "Run" button (or press F5 key) to run it.
Step 5. Click on OK when a small box pops up and close the VBA window, you will find your Excel sheet has been unprotected without the password.

Unprotect Excel file by VBA code.

Method 3. Try free password removal tool to restore Excel file without password

If you need a professional software or tool to help you remove password protection on your Excel file or unlock Excel file without a password, you may try the recommended password removal tools:

  • Excel Password Remover.
  • Excel Password Recovery Lastic.
  • Excel Password Genius.
  • ...

You can selectively download any one of the recommended tools online and let it help you unlock Excel file without password right now. If you happen to meet the problem of Excel unsaved, here is the online help on how to recover unsaved Excel file Mac you can ask for. 

 
 

100% of people found this article helful.

 

Frequently Asked Qusetions

1. Why cannot I recover 2GB data for free?

It is recommended to check the version installed is Free or Trial because they are different versions.

Trial has data preview function but cannot save any files, while the Free version enables to recover 2 GB files. The default free space is 500 MB and you may share the product on social media to get another 1.5 GB.

2. Why cannot the recovered files be opened?

A file is saved as 2 parts on the storage device: directory info (which is comprised by file name, time stamp and size info, etc.) and data content.

If the files with original file names and folder structures cannot be opened, one possible reason is the corrupted directory info. There is still a chance to recover the data content with the RAW Recovery method in our software.

3. Why isn't it suggested to recover the files back to the original drive?

The storage structure of the lost files would be altered or damaged by any changes on the drive. If you save the recovered files back to the same drive, the original data structures and data content would be corrupted or overwritten, which causes permanent data loss. So you should prepare another disk to save the files.

4. How can I check whether my data is recoverable or not before purchase?

The Free version helps you save 2GB files to better verify the recovery quality of our product before purchase.

5. How long does it take to scan the drive?

It strongly depends on the capacity of your hard drive and the performance of your computer. As reference,most drive recoveries can be completed in around 10 to 12 hours for a 1-TB healthy hard drive in general conditions.

About Data Recovery Wizard

It's super easy to recover 250+ types of files after deletion, disk formatting and virus infection. Click the links and compare the difference of each version.