Most of us are excel users, and if you aren’t, you might be bound to analyze a lot of data either from office or home. Besides, some still need to handle data from shops and larger organizations. But wait, losing this valuable data doesn’t need you to be careless. Imagine you have some important data you want to analyze, but the excel file is encrypted. You’ll have to know how to decrypt a excel file that is encrypted anyway or forget all about the task at hand.
I’ll start this by quoting someone who came to me with a problem;
“I’m currently in a mess, having lost a valuable excel file that I had safely encrypted with a password. I’ve looked for the file everywhere, and I can’t find it.”
Are you experiencing this issue? Don’t worry for you don’t need to do that again.
In this article, I’ve provided the long waited solution that will guide you on how to decrypt excel file without password. By following these instructions, it becomes easy even to learn to decrypt excel file.
If you are stuck on an excel file password protection and cannot open it, then use VBA code method to decrypt excel password. The code used in this method is simple and anyone can use it following the instructions. VBA code is used to recover excel worksheet passwords without losing important data. The following are the steps on how to decrypt excel password using this method.
Step 1. Create a new MS Excel file. Press ALT+F11 simultaneously to open the VBA window.
Step 2. Select Insert and click on Module.
Step 3. Press the F5 key to run button, or rather, click on Run to run the button.
Step 4. Upon popping up of a small box, click on OK.
Step 5. Close the VBA window. This will lead you to your excel file decrypt without a password.
If you still struggle to find out how to decrypt excel file without password, try this second option. Some of us find it difficult to remember the passwords we used to encrypt our Excel files. Besides, it turns into headaches when we want to decrypt excel file without password. This is quite easy, as there’s no official way to go about it. With the many tools in this industry offer this function. After testing and using the Passper for excel, it’s proven to be the best excel password recovery option to turn to if you wish to remove passwords from your Excel files without losing your data. Besides, this tool doesn’t require any password, thus the process is hassle-free.Free Trial
Here are a few steps to decrypt excel password via Passper for excel:
1.1 Find and Remove the Opening Password for Excel Workbook
1.Open Passper for excel on your PC and click on “Recover Passwords” on the main computer window.
2.Click on “+” button to find and open the password-protected excel file. This leads you to various attack modes forms that one can use with Passper for excel. Each mode is well explained to help you choose the one that best suits you. After choosing your attack mode, click on Recover.
3.After clicking on “Recover”, the software starts to recover the file password. The time spent to recover the password is determined by the attack mode you’ve chosen. After the recovery, the software will display the password on the screen.
This is the most common method for users who find it hard to edit worksheets whose structure is locked. This method uses ZIP software to decrypt Excel file. The following steps will help you to solve the file puzzle.
1.Change the extension of your file from “xlsx”-“Zip”. The file extension is then displayed after the name of the excel file.
2.Extract the created Zip file by using “WinRAR” or “7zip” or any other zip extractor. Click on the zip file, and then select “Open Archive”. Use your preferred zip extractor to open the archive.
3.Open the worksheets and “xl” folders to have all the files sheets. Each sheet will then be labeled as “sheet 1.xml”.
4.Right-click on the protected worksheet to edit. The worksheet will be opened in notepad.
5.Click on “Ctrl+F” button on your PC keyboard. You’ll get the “sheet protection” in the Excel file. The algorithm information used to lock the sheet will be displayed. Delete every information closed in the bracket, plus the word “Sheet protection”. Save the file.
6.Find the folder in which you’ve saved the worksheet. Click on the “xl” folder to open. You will have the “workbook.xml” file in the “xl” folder.
7.Right-click on “workbook.xml” and select “edit”. A notepad will be created. Delete≤workbookProtection…/≥. Save the excel file.
8.Change the file name from “zip” to “xlsx”. When you now open the password protected Excel file, you’ll realize that you can easily edit it without password.
If you still remember the file password, things will be easier for you. Although the options for other versions of MS Excel are different, the outcomes are still the same. The following steps will help you learn how to decrypt excel file with password.
How to Decrypt Excel File with Password for MS Excel 2010 And Above
1.Open the protected Excel file and key in the right password.
2.Select “File” on the top left side of the menu. Select “Info”, and then tap on “Protect Workbook” provided on the “permission” option.
3.Tap on “Encrypt with password” option on the drop down menu.
Remove the password. Click on “OK”.
For Excel 2003 and above
Here are the steps for excel 2003 and above:
1. Open the encrypted excel file and enter the accurate password.
2. Go to the menu bar and pick the Tools option. Now choose Options.
3. There will appear a new window, go to Security option from all the available options.
4. Go to the Password to open option and remove it.
5. Press on OK and save the file.
The article has effectively covered the three methods on how to decrypt excel file without password easily without having to worry about facing any problem. The most effective method among all of three is decrypt excel file with the help of Passper for excel. Just follow the simple steps and instructions of second method, and you’ll have your file back, safe and intact, without having been damaged. With the shared knowledge on how to decrypt password in excel, you as well become an expert.Free Trial