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:
- Download and install Excel Password Unlocker on your computer.
- Open Excel Password Unlocker and click on the “Open” button to import the locked Excel file.
- 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.
- Click on the “Start” button to initiate the password recovery process.
- Once the password has been recovered, the software will display it on the screen. Use the password to unlock the Excel file.
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:
- Download and install Passper for Excel on your computer.
- Open Passper for Excel and click on the “Add” button to import the locked Excel file.
- 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.
- Click on the “Start” button to initiate the password recovery process.
- 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:
- Download and install the software on your computer.
- Open the software and import the locked Excel file.
- Choose the attack mode that you want to use. The software will offer multiple attack modes.
- Click on the “Start” button to initiate the password recovery process.
- Once the password has been recovered, the software will display it on the screen. Use the password to unlock the Excel file.
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:
- Open the password-protected Excel file and press “Alt + F11” to open the VBA Editor.
- Insert a new module by clicking on “Insert” and selecting “Module”.
- 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
- Close the VBA Editor and return to the Excel file.
- Press “Alt + F8” to open the Macro window.
- Select the PasswordBreaker macro and click on “Run”.
- 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.
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:
- Open the password-protected Excel file.
- Enter the password when prompted.
- Click on the “File” tab and select “Info”.
- Click on the “Protect Workbook” button and select “Encrypt with Password”.
- Delete the password from the text box and click on “OK”.
- 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.