CARA MEMBUKA FILE EXCEL YANG TIDAK BISA DIBUKA KARENA TERKUNCI

Have you ever encountered a situation where you are unable to open an Excel file due to a password protection? It can be extremely frustrating, especially when you urgently need to access the data within. In this article, we will discuss some effective solutions to help you unlock password-protected Excel files.

Cara Membuka Password File Excel Yang Terproteksi

If you have forgotten the password to your Excel file, don’t worry, you are not alone. It is a common problem faced by several users. In such cases, you can try one of the following solutions:

1. Use a Password Recovery Tool

A password recovery tool can help you to recover the password to your Excel file. There are several password recovery tools available online, but it is important to choose a reliable one. One such tool is PassFab for Excel. It is a powerful tool that can recover passwords of any length and complexity within minutes.

Here are the steps to use PassFab for Excel:

1. Download and install PassFab for Excel on your computer.
2. Open the software and click on “Add” to select the password-protected Excel file.
3. Choose the attack type based on the complexity of your password and click on “Start”.
4. The software will start the password recovery process and within a few minutes, the password will be displayed.

2. Use a Macro to Remove the Password

If you do not want to use a password recovery tool, you can try using a macro to remove the password from your Excel file. However, this method only works if the sheet is not protected.

Here are the steps to remove the password using a macro:

1. Open the password-protected Excel file.
2. Press ALT + F11 to open the VBA editor.
3. Click on “Insert” and then select “Module”.
4. Paste the following code in the module window:

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 “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

5. Press F5 to execute the macro.
6. The password will be displayed in a message box.

Cara Membuka Excel Yang Di Protect Menghapus proteksi sandi pasword

If your Excel file is protected and you know the password, but for some reason, you are unable to make changes to it, it might be because the sheet is protected. In such cases, you can try removing the protection by following these steps:

1. Open the password-protected Excel file.
2. Click on the “Review” tab.
3. Click on “Unprotect Sheet”.
4. Enter the password and click on “OK”.
5. The sheet will now be unprotected and you can make changes to it.

Cara Membuka File Excel Yang Tidak Bisa Dibuka

Sometimes, you might encounter a situation where you are unable to open an Excel file due to corruption or some other issue. Here are some solutions that can help you to open a corrupted Excel file:

1. Use the Open and Repair Option

The Open and Repair option is an in-built repair tool in Excel that can help you to open a corrupted file. Here’s how to use it:

1. Open Excel and click on “File”.
2. Click on “Open”.
3. Select the corrupted Excel file and click on the arrow next to the “Open” button.
4. Select “Open and Repair”.
5. Click on “Repair” to start the repair process.
6. Once the process is complete, the file will be opened.

2. Use a Third-Party Recovery Tool

If the Open and Repair option does not work, you can try using a third-party recovery tool. These tools are designed to repair and recover corrupted Excel files. One such tool is Stellar Repair for Excel. It is a powerful tool that can repair and recover corrupt Excel files and restore the data within.

Here are the steps to use Stellar Repair for Excel:

1. Download and install Stellar Repair for Excel on your computer.
2. Open the software and click on “Select File” to choose the corrupted Excel file.
3. Click on “Scan” to start the scanning process.
4. Preview the recovered data and select the files you want to save.
5. Click on “Save” to save the recovered data.

FAQ

1. Can I unlock a password-protected Excel file without the password?

Yes, you can unlock a password-protected Excel file without the password using a password recovery tool or by using a macro to remove the password.

2. What should I do if I am unable to open a corrupted Excel file?

If you are unable to open a corrupted Excel file using the Open and Repair option, you can try using a third-party recovery tool like Stellar Repair for Excel.

Video Tutorial