How Can We Open A Password Protected Excel File?

There are a few ways to open a password protected Excel file. One is with known password and the other is by modifying the file extension. A password protected file can be opened online and a corrupted file can be opened using Stellar File Repair.

Jun 08, 2020 • Filed to: Recover & Repair Files • Proven solutions

0
Q. Can I remove or change workbook passwords?
Ans. Yes you can remove or change workbook passwords. In fact, anybody who knows the current password can remove or change workbook passwords. The steps are pretty simple. All you have to do is open the desired workbook and click on Unprotect Sheet, which will remove the password. To change the password, click on Protect Workbook and type and confirm the new password.

Summary

It is definitely possible to open a password protected Excel file. This post is all you need to make your spreadsheet workable once again. More often than not, we make the use of password to protect our important files from being mishandled by our rivals or even our children sometimes. However, many people have a problem of forgetting their passwords.

Protecting your important files with a password has become a sort of a must for everybody. With the ever increasing cases of cyber theft, one always has to be on their toes when it comes to work related data and numbers. Whether it is your personal computer or laptop, or your electronic device at your office, each of them should always be password protected to save yourself the trouble later.

But why would somebody want to password protect their Excel file? Well, Excel files are employed by most big and small companies to keep a track record of their finances, growth, input, output, and almost everything else that is business related. Under such circumstances, when everything can be found in Excel files, they hold the whole circulatory system of your business. Thus, protecting them becomes a necessary. However, since so many files – personal and professional are password protected, remembering so many passwords has become a task in itself too.

If you are somebody who is stuck with an Excel spreadsheet because you too put up a password and now cannot seem to remember it, we have got you covered with this post. We are about to teach you a few things with this article such as how to open password protected Excel file with known password, how to unprotect Excel spreadsheet without Software with the help of VBA Code, how to view or open a protected Excel file by modifying the file extension, and how to unlock a password protected Excel file online.

In addition to all these solutions, this post will also act as your guide on how you can open a corrupted Excel file with the aid of Stellar File Repair.

Part 1. How to Open Password Protected Excel File with Known Password

Since you are already aware of the password, part 1 is the simplest, easiest, and the least time consuming part. All that needs to be done by you is that you have to enter the password and the file will be opened in front of you in a matter of seconds.

These are the steps you can undertake to open password protected Excel file with known password:

  1. Open File – The first step is to go to the location where your to-be opened file is and double click on it. You can also right click on the desired file and select the ‘open’ option. While there are other ways of opening the file too, these two are the most often selected ones.
  2. Enter Password – Since the sheet you are striving to open is password protected, you will be greeted with a pop up where you will be asked to enter the password which will unprotect the sheet. Once unprotected, you will be able to see the contents of the sheet.
  3. password-protected-file-repair-photo-1

  4. Click OK – Once you have entered the password, you will have to click on the ‘OK’ option which is present on the bottom right of the pop up. This will lead you to the file, ready for you to see and work on it.

Another reason why this part has been termed as the easiest and fastest of all is because no matter which Excel version you are using – Excel 2007. Excel 2010, Excel 2016 or any other Excel version for that matter, the steps for each of them are the same.


Part 2. How to Unprotect Excel Spreadsheet without Software by VBA Code?

Microsoft developed a programming language named VBA which is a part of Microsoft Office. VBA is the acronym for Visual Basic for Applications and is used to accomplish thousands of different tasks such as maintaining a list of various things, helps you in forecasting & budgeting, helps you in analysing scientific data & also aids in developing charts.

One of its feature from its basket of tasks is its ability to help you unprotect Excel spreadsheet without software. And it can be done by simply undertaking these 4 steps. Here they are:

  1. Open Excel File – The primary thing you have to do is open the Microsoft Excel file in question.
  2. Open VBA Editor – The simplest way to open VBA Editor is by pressing Alt key and F11 key simultaneously.
  3. Insert Module – The next step is to insert a module for Insert Menu
  4. Enter Code – Once the code window is open in front of you, you will have to insert the following lines of code.
  5. Sub UnProtectWorkbook()

    On Error GoTo ErrorOccured

    Dim pwd1 As String, ShtName As String

    pwd1 = InputBox("Please Enter the password")

    If pwd1 = "" Then Exit Sub

    ShtName = "Workbook as a whole"

    ActiveWorkbook.Unprotect Password:=pwd1

    MsgBox "The workbook's structure has been Unprotected."

    Exit Sub

    ErrorOccured:

    MsgBox "Workbook could not be UnProtected - Password Incorrect"

    Exit Sub

    End Sub

  6. Save the File – After having entered the above code lines into the code window, press on the ‘Save’ button. Your file will be saved a macro enabled workbook.
  7. Press F5 – In order to execute the above steps of action, press F5.

Once you follow the steps carefully, you will be able to unprotect Excel File without software by VBA Code.


Part 3. How to View / Open Protected Excel by Modifying the File Extension?

While these steps might not exactly be the best fit for newer Microsoft Office versions, they work amazingly well for Microsoft Office 2010 or any previous versions of the same.

You will be able to view or open protected Excel Files by modifying the file extension by following these super simple and straightforward 10 steps:

  1. Create Backup – One of the most important thing you have to do even before the procedure begins is to create a backup of the Excel file that is protected with a password.
  2. Rename File – After having created a backup, you need to rename the file by right clicking on the excel sheet and clicking on the ‘rename’ button.
  3. Change Extension – Whether your file has a .csv extension or an .xls extension, it is time for you to change it to .zip extension.
  4. change-extension-file-repair-photo-2

  5. Unzip Content – After having renamed the file and having changed the extension to .zip, it is time to unzip the content from the zip file.
  6. Search File – Now you need to search for the file that ends with an .xml format.
  7. Open File – After having found the file with .xml format, click on that file and open it with XML editor.
  8. open-file-for-file-repair-photo-3

  9. Press ‘Ctrl + F’ – Pressing the Ctrl button and F together will let you find for your desired word. In this case, you are searching for the word ‘SheetProtection’. You need to search for

    sheet-protection-file-repair-photo-4

  10. Remove that Word – Once you have found that word, remove it from the file.
  11. Save File – After removing the word from the file, save it.
  12. Change Extension – Once you have saved the file, change back the file extension from .zip to .xls or .csv, whichever you prefer or want.

When you have successfully undertaken all the 10 steps written above, all your worksheets will be rendered unprotected. This means, you will be able to open any of your file without having to type in the password.


Part 4. How To Unlock A Password Protected Excel File Online?

If you are thinking about using any online tool to unlock a password protected Excel file, then the first thing you need to make sure is to have a strong and reliable internet connection so as to safe yourself from any obstruction while the task is being done.

While we are at it, it is also important to know that not all files can be unlocked. Thus, it will not be wrong to say that online methods of unlocking a password protected Excel file work only when the strength of the password is not too strong. Also, it is not an entirely safe way of getting your Excel file unlocked. Thus, you should go for online methods only if the file in question does not contain life altering data.

Since you have decided to go with online ways, here are 5 steps you will have to undertake to get your Excel file unlocked:

  1. Open Site – Open the online portal you have chosen for your task.
  2. Upload File – Once you open the online window on your computer, you will see an option that says ‘Drop file to upload or click here’. You can either drop the Excel file from another window or you can click on the ‘click here’ option to search and upload your desired file.
  3. upload-your-desired-file-for-file-repair-photo-5

  4. Sit Back & Relax – Your job here is almost done because after uploading the file, the password recovery process will commence and start to do its work. The time it will consume depends on various factors and one of the most important of those is the password strength. You can anytime see the progress of the process of recovery on the screen.
  5. Note Down the Password – Once the recovery process is completed, you will be able to see the cracked password on your screen. You can take a note of your password so that you do not forget it the next time.

Part 5. How to Open a Corrupted Excel File?

All of us have faced this issue when our file does not open because it is corrupted. The problem can become graver if you do not have a backup of your files.

The best and the simplest way though is to make use of Stellar Repair for Excel software because it lets you open your corrupt files which did not have any backup.

There are 3 main methods that can help you open a corrupt Excel file:

1. Open and Repair Method –

You can manually repair damaged Excel files with Open and Repair Method and does not require backup as well. Here are the steps that should be followed:

repair-method-photo-6

2. Excel File Repair Software –

Third party tools can be used to open corrupt files but one has to be exceptionally careful while choosing this third party. Make sure this third-party tool is reliable and has the ability to perform multiple tasks.

Stellar Repair for Excel is the most widely suggested tool to perform such kind of functions. This software can effectively and easily repair XLS as well as XLSX files. Also, Stellar repair is available for both Windows and Mac OS. Here are some of the added advantages:

3. Excel Auto Backup and Auto Recover Features –

The newer versions of Excel come with two new features to reduce the chances of losing data in files due to file crash, accidental deletion, power outrage or any other reason. These two features are named Excel Auto Backup and Excel Auto Recover.

Steps to Repair Excel file with Stellar File Repair:

  1. Download Stellar Repair software
  2. Install and launch it
  3. On the Home screen, you will find a few options. Select the one which let’s you select the corrupted Excel files
  4. steps-to-repair-excel-file-photo-7

  5. Click on the ‘browse’ option which lets you select XLS and XLSX files
  6. excel-repair-photo-8

  7. Once you have selected the file/files, click on the ‘repair’ prompt to initiate the process of repairing
  8. Once the scanning ends, you will be able to see all the recoverable items in the left-hand side. Any of these can be previewed by double-clicking
  9. excel-solver-photo-9

  10. Click on the ‘save file’ prompt once you are satisfied with the preview.
  11. Choose the destination of your choice and click on ‘ok’
  12. save-your-repair-file-photo-10

Video Tutorial on How to Recover an Unsaved/Deleted Word Document?

Recent Videos from Recoverit

View More >

Amy Dennis

staff Editor

0 Comment(s)
Home > Resources > Recover & Repair Files > Is It Possible To Open A Password Protected Excel File?