Have you ever wondered what can Microsoft Excel do? Well the answer would be INNUMERABLE things! Yes this is one of the finest creations of Microsoft which has allowed users to arrange and organize data in a much more accessible way. It is one of the various programs that comes with the Microsoft Suit. It is an advanced version of spreadsheet or worksheet which basically uses macro programming for Visual Basic for Applications (VBA) and is thus equipped with features, such as pivot table, pie chart, arithmetic calculations, percentage computation, and graphical representation of data, sorting data, and many more things with endless varieties. In fact it is so advanced in its own way that it has literally replaced the standardized spreadsheet used earlier that is LOTUS 1-2-3.
Now if you can understand the importance of an excel file which could be a sorted worksheet of salary details, customer phones numbers and personal credentials, employees office entries, etc, then you must understand how important it is to protect these data from being fallen into the wrong hands. Therefore, Microsoft Excel allows password protection feature to secure the data from being exploited by intruders and strangers.
But now the problem is that if you can’t open the locked Excel file for a while, then you are most likely to forget Excel password in time and this is what we are going to deal with in this very article. Yes, indeed it is going to create a havoc if you have lost or forgotten your Excel spreadsheet password, but you need not worry as this article would demonstrate you two simple solutions which will easily guide you to remove your Excel password protection without losing any data.
Solution #1: Remove Excel Password Feature Manually
If an excel file is password protected then on double-clicking the file, it would ask you for the password which of course you have forgotten here. Thus we would simply remove the password protection feature altogether to turn around the issue. The steps for the directive are laid out as follows:
Step 1. Go to windows menu and click on Microsoft Excel application from the Microsoft Office suite to open the application. You can also click “Start” and type “Excel” in the search box. Once the list of options turns up click on the “excel” option and the program will turn up.
Step 2. Now when the interface screen appears click on “File” option from the menu bar, and then “Info” and “Permissions” options from the sub-menu.
Step 3. Click “Entry with Password” option from the sub-menu and the password entry box emerge.
Step 4. When the password entry box emerges, delete the already remaining password to leave the box completely empty. Click “Ok” to remove the password and click “Save” to save the changes. That’s it!
Now open the same locked excel file again, and double-click on it. Instead of asking any password entry, it will swiftly open the spreadsheet file without any issue which indicates that your job is done efficiently.
If you are not satisfied with this method, there is another one waiting ahead.
Solution #2: Remove Excel File Password by Changing File Extension
This is a bit a twisted method, but ensures 100% guaranteed result as expected. So here in this section, we are basically going to change the file extension of the excel file and would manipulate the contents to get an unprotected excel file.
Step 1. Open your password protected excel file which on double-click denies to be opened without any password, and what it would look like is shown below in the image.
Step 2. Now go to the “Control Panel” and follow the particular pathway:
Folder Options > View Tab
Step 3. Now in the view tab uncheck the “Hide Extension for known file type” check box.
Step 4. Next you have to change the extension of your excel file from .xlsx to .zip.
Step 5. Open the excel file in a notepad and delete the following tag which is usually marked in double quotes:
2007-10 – “sheetProtection password=… />”| v. 2013 – “sheetProtection algorithmName=…/>”
Step 6. Now save the XML file and put it back into the zip folder in the extracted location as it will replace the original XML file.
Step 7. In the last step change the extension back to .xlsx from .zip.
And there you go, now if you open up your excel file it would not ask you for the password entry as the protection feature has been bypassed from the locked excel file. So access it and enjoy.
Password protection to your excel file is very important which you can’t deny as it contains the most essential data of your personal credentials. But it is equally important for you to remember the password or at least keep it noted down somewhere safely to avoid these mishaps. But anyhow even if you forget it for a while, since we have got your back, you can use the article methods to remove Microsoft Excel password to access your data again without any issue.