Excel is one of the most widely used spreadsheet programs in the world, and many people use it to store important information. However, sometimes you may forget the password to one of your Excel files, making it impossible for you to access its data. In this article, we will show you some simple and effective ways to open locked Excel files without needing the password.
Cara Membuka Password Excel Dengan Mudah Paling Ampuh
One of the most common ways to protect an Excel file is by setting a password to open it. If you have forgotten the password, there are several ways to recover it.
Method 1: Using an Online Tool
One of the easiest ways to recover the password of an Excel file is by using an online tool. These tools are easy to use and can help you recover the password within a few minutes. Here are the steps to follow:
- Go to an online Excel password recovery website. There are several websites available, such as Free Online Converters.
- Upload the Excel file that you want to recover the password for.
- Click on the “Recover Password” button to start the recovery process.
- Wait for the website to recover the password. This process may take a few minutes depending on the complexity of the password.
- Download the recovered password and use it to open your Excel file.
Using an online tool is one of the easiest ways to recover the password of an Excel file. However, it may not be safe to use these tools as they may compromise the security of your data. Therefore, it is recommended to use this method only if you have no other options.
Method 2: Using a VBA Code
An alternative way to recover the password of an Excel file is by using a VBA code. This method may not work for all Excel files, but it is worth a try. Here are the steps to follow:
- Open a new Excel file and press ALT + F11 to open the VBA editor.
- Copy and paste the following code into the editor:
- Save the file as a macro-enabled Excel file (.xlsm).
- Close the editor and open the locked Excel file that you want to recover the password for.
- Press ALT + F8 to open the Macro window.
- Select the PasswordBreaker macro and click on the “Run” button.
- Wait for the macro to finish running. It may take a few minutes depending on the complexity of the password.
- Once the macro finishes running, a usable password will be displayed.
- Use the displayed password to unlock your Excel file.
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
The VBA method is more complicated than the online tool method, but it is safer to use as you do not need to upload your data to an external website. However, this method may not work for all Excel files and may take longer to recover the password.
Cara Membuka File Excel Yang Terkunci Lupa Password
If you have forgotten the password to an Excel file, you can use several methods to unlock it. Here are some of the best ways to unlock an Excel file without needing the password:
Method 1: Using a ZIP Utility
If you know the structure of an Excel file, you can unzip it and remove the password protection without needing the password. Here are the steps to follow:
- Create a copy of the locked Excel file that you want to unlock.
- Change the file extension of the copied file from .xlsx to .zip.
- Right-click on the ZIP file and select “Extract All”.
- Open the extracted file and navigate to the “xl” folder.
- Delete the “workbook.xml” file.
- Open the “sheet*.xml” file with a text editor and remove the “sheetProtection” tag.
- Save the edited file and close it.
- Right-click on the edited file and select “Add to Archive”.
- Change the file extension of the archive from .zip to .xlsx.
- Open the new Excel file and you should be able to access the data without needing the password.
This method may not work for all Excel files and can be time-consuming. However, it is one of the most effective ways to unlock a locked Excel file without the password.
Method 2: Using an Online Service
If you are unable to unlock the file using the ZIP utility method, you can use an online service to unlock the file. Here are the steps to follow:
- Go to an online Excel unlocker service. There are several websites available, such as Online Tech Tips.
- Upload the Excel file that you want to unlock.
- Wait for the website to unlock the file. This process may take a few minutes depending on the complexity of the password.
- Download the unlocked Excel file and access the data without needing the password.
Using an online service can be a quick and easy way to unlock a locked Excel file, but it may not be safe to use these services as they may compromise the security of your data. Therefore, it is recommended to use this method only if you have no other options.
FAQ
Q: Can I recover the password of an Excel file using a VBA code?
A: Yes, you can use a VBA code to recover the password of an Excel file. However, this method may not work for all Excel files and may take longer to recover the password.
Q: Is it safe to use an online tool to recover the password of an Excel file?
A: It is not recommended to use an online tool to recover the password of an Excel file as it may compromise the security of your data. Therefore, it is recommended to use this method only if you have no other options.
In conclusion, if you have forgotten the password to an Excel file, there are several ways to unlock it without needing the password. You can use an online tool or a VBA code to recover the password, or you can use a ZIP utility or an online service to unlock the file. However, it is recommended to use these methods only if you have no other options as they may compromise the security of your data.