CARA MEMBUKA FILE EXCEL BERPASSWORD

In today’s digital age, documents are often stored and shared in electronic format. One of the most commonly used formats for storing and sharing data is Microsoft Excel. However, sometimes we may encounter Excel files that are locked or password-protected, preventing us from accessing the data within. In this article, we will discuss various methods of unlocking and accessing password-protected Excel files.

Cara Membuka File Excel yang Terkunci

There are several ways to unlock Excel files that are password-protected. Here are a few methods that you can try:

1. Using Excel Password Unlocker

Excel Password Unlocker is a software program that is specifically designed to unlock password-protected Excel files. The software uses advanced algorithms and brute-force techniques to break the password and unlock the file. To use Excel Password Unlocker:

  1. Download and install Excel Password Unlocker on your computer.
  2. Open Excel Password Unlocker and click on the “Open” button to import the locked Excel file.
  3. Choose the attack mode that you want to use. Excel Password Unlocker offers three attack modes: Brute-force Attack, Brute-force with Mask Attack, and Dictionary Attack. Each mode uses a different approach to break the password.
  4. Click on the “Start” button to initiate the password recovery process.
  5. Once the password has been recovered, the software will display it on the screen. Use the password to unlock the Excel file.
Baca Juga :  BAGAIMANA CARA INSERT PICTURE EXCEL 2010

2. Using Passper for Excel

Passper for Excel is another software program that can be used to unlock password-protected Excel files. The software uses four different attack modes to break the password and unlock the file. To use Passper for Excel:

  1. Download and install Passper for Excel on your computer.
  2. Open Passper for Excel and click on the “Add” button to import the locked Excel file.
  3. Choose the attack mode that you want to use. Passper for Excel offers four attack modes: Brute-force Attack, Mask Attack, Dictionary Attack, and Smart Attack. Each mode uses a different approach to break the password.
  4. Click on the “Start” button to initiate the password recovery process.
  5. Once the password has been recovered, the software will display it on the screen. Use the password to unlock the Excel file.

Cara Membuka Password File Excel

If you have forgotten the password for an Excel file, there are still ways to recover it. Here are a few methods that you can try:

1. Using a Third-Party Software

There are several third-party software programs available online that can be used to recover the password for an Excel file. Some popular options include Excel Password Recovery, Stellar Phoenix Excel Password Recovery, and Atomic Excel Password Recovery. To use these software programs:

  1. Download and install the software on your computer.
  2. Open the software and import the locked Excel file.
  3. Choose the attack mode that you want to use. The software will offer multiple attack modes.
  4. Click on the “Start” button to initiate the password recovery process.
  5. Once the password has been recovered, the software will display it on the screen. Use the password to unlock the Excel file.
Baca Juga :  CARA EXCEL TANDAIN DOUBLE DATA

2. Using a Macro

If the password for the Excel file is relatively simple, you may be able to use a macro to recover it. Here’s how:

  1. Open the password-protected Excel file and press “Alt + F11” to open the VBA Editor.
  2. Insert a new module by clicking on “Insert” and selecting “Module”.
  3. Paste the following code in the new module:
    Function PasswordBreaker(password As String)
       '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
                  PasswordBreaker = 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 Function
              End If
       Next: Next: Next: Next: Next: Next
       Next: Next: Next: Next: Next: Next
    End Function
            
  4. Close the VBA Editor and return to the Excel file.
  5. Press “Alt + F8” to open the Macro window.
  6. Select the PasswordBreaker macro and click on “Run”.
  7. The macro will start running and will try different combinations of passwords until it finds the correct one. Once the password has been found, it will be displayed on the screen.
Baca Juga :  CARA BUAT KURVA DI EXCEL

Cara Membuka Password File Excel Yang Terproteksi

If you have an Excel file that is protected, but you know the password, you can easily unlock it. Here’s how:

  1. Open the password-protected Excel file.
  2. Enter the password when prompted.
  3. Click on the “File” tab and select “Info”.
  4. Click on the “Protect Workbook” button and select “Encrypt with Password”.
  5. Delete the password from the text box and click on “OK”.
  6. Save the changes by clicking on the “Save” button.

Once you have removed the password, you will be able to access the data in the Excel file without any restrictions.

FAQ

1. What should I do if I cannot remember my Excel file password?

If you cannot remember your Excel file password, you can try using a third-party software program to recover it. There are several options available online that can help you recover the password. Alternatively, you can try using a macro to recover the password if it is relatively simple.

2. Is it possible to unlock a password-protected Excel file without using any software?

It is possible to unlock a password-protected Excel file without using any software, but only if the password is simple. In such cases, you can try using a macro to unlock the file. However, if the password is complex, you will need to use a software program to unlock the file.