Opening locked Excel files can be a daunting task. Sometimes, users tend to forget their password, or they receive a file from someone who had previously protected the file with a password. Whatever the reason is, you can still access your file by using several methods.
Cara Membuka File Excel yang Terkunci Tanpa Aplikasi
One of the easiest ways to unlock a password-protected Excel file is through the password recovery option. This feature is built into Excel, and it enables you to recover lost passwords without needing a third-party app.
The first thing you need to do is launch Excel and open the password-protected file. You will see a pop-up window that prompts you to enter the password. Instead of entering the password, click on the “File” menu located in the top-left corner of your Excel screen.
A drop-down menu will appear, and you need to click on the “Info” option. You will see another drop-down menu, which displays several options. Look for the “Protect Workbook” option, and click on it. You will see several options again. Choose “Encrypt with Password.”
A new pop-up window will appear that prompts you to enter a new password to replace the old one. But since you don’t know the old password, leave the old password box empty, and enter a new password in the “New Password” box. Re-enter the new password in the “Confirm Password” box, and click on “OK.”
Excel will accept the new password, and it will override the old password without needing the old password. This method is simple and easy to follow. After resetting the password, you will have access to your locked Excel file.
Excel Terkunci Tidak Bisa Mengetik
Another method to unlock a password-protected Excel file is by using an online tool that unlocks the file. These online tools can be found on various websites. They tend to be user-friendly and provide step-by-step guidance on how to unlock the file.
To start, launch your web browser and search for “Excel password unlocker.” You will see several online tools that offer to unlock password-protected files. Some popular tools are Password-Find, Online Hash Crack, and Lost My Pass.
Choose a tool that suits your needs and click on it. You will be redirected to its homepage. On the homepage, you will see a button labeled “Browse” or “Choose File.” Click on it, and it will prompt you to select the password-protected Excel file from your computer.
After selecting the file, click on the “Unlock” or “Decrypt” button located on the website. Wait for a few moments as the tool works its magic, and it will provide you with a download link to your unlocked Excel file.
It is important to note that these online tools are not always reliable, and they may not work for some files. Moreover, it is important to consider the security of using an online tool.
Cara Membuka File Excel Yang Terkunci Password
If you do not want to use an online tool or Excel’s password recovery option, you can use third-party software to open a locked Excel file. This software is designed to recover lost passwords and can open files protected with complex passwords.
One of the best third-party tools available for unlocking Excel files is PassFab for Excel. This software is easy to use and provides quick results. To use PassFab for Excel, follow the steps below:
- Download and install PassFab for Excel on your computer.
- Launch the software and select the “Recover Excel Open Password” option.
- Browse and select the password-protected Excel file from your computer and click on “Next.”
- Choose a password recovery mode that suits your needs. PassFab for Excel offers three password recovery modes:
- Dictionary Attack
- Brute-force with Mask Attack
- Brute-force Attack
- Click on “Start” and wait for some time as the software tries all possible password combinations.
- When the password is found, it will be displayed on the screen.
Cara Membuka File Excel yang Terkunci
Another method to open a locked Excel file is by using a macro. This method is useful when you know the password but cannot open the file. The macro method is built into Excel and can be used without needing any third-party software.
To use the macro method, follow the steps below:
- Launch Excel and open the password-protected file.
- Press the “Alt + F11” keys on your keyboard to open the VBA editor.
- Click on “Insert” on the menu bar and select “Module.”
- Copy and paste the following code in the module:
- Click on the “File” menu and select “Close and Return to Microsoft Excel.”
- Click on the “Tools” menu and select “Macro” -> “Security.”
- Set the security level to “Medium,” and click on “OK.”
- Click on “Tools” -> “Macro” -> “Macros,” select “PasswordBreaker,” and click on “Run.”
- When the macro finishes running, you will see a pop-up box with a usable password.
Sub PasswordBreaker()
'
'Breaks worksheet password protection.
'
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub
Frequently Asked Questions (FAQ)
Q: What should I do if I tried all methods, but I still can’t open my locked Excel file?
A: If none of the methods listed above work, you can try contacting Microsoft’s customer support team. They may be able to assist you in opening your locked file or provide further guidance on what you should do next.
Q: Is it safe to use online tools to unlock password-protected Excel files?
A: It depends on the online tool you use. Some online tools may not be reliable, while others may work perfectly fine. However, it is important to be cautious when using online tools, and you should only use reputable websites that offer safe and secure services.
Video Tutorial: How to Unlock Password-Protected Excel Files
Unlocking a password-protected Excel file may seem like a difficult task, but with the right methods, you can easily access your file. Whether you want to use Excel’s password recovery option or third-party software, there is always a solution to unlocking your file. Always remember to keep your passwords safe and secure to avoid the hassle of unlocking a locked file.