Have you ever encountered a situation where you have an Excel file that is password-protected and you don’t have the password to open it? Fear not, as there are several methods that you can try to unlock your file. In this article, we will explore some of the ways to unlock password-protected Excel files.
Cara Membuka Password File Excel
If you are using Microsoft Excel 2010 or a later version, you can follow these steps to unlock your password-protected file:
- Open the Excel file that is password-protected.
- Click on “File” on the top left-hand corner of the screen.
- Click on “Info” and then click on “Protect Workbook”.
- Select “Encrypt with Password”.
- Delete the current password and leave the field blank.
- Click on “OK” and save the file.
If the above method does not work, you can try to use an online tool to unlock your Excel file. One of the popular tools that you can use is Password-Find. Here’s how:
- Go to the Password-Find website.
- Click on “Choose file” and upload the password-protected Excel file.
- Click on “Submit” and wait for the tool to crack the password.
- Once the password is cracked, download the unlocked version of the Excel file.
Cara membuka file Excel yang dikunci / dilindungi (+ gambar) | Berita Tekno
If you don’t want to use an online tool to unlock your Excel file, you can try to use VBA code to unlock your file. VBA stands for Visual Basic for Applications, and it is a programming language that is embedded in Microsoft Excel. Here’s how to use VBA code to unlock your file:
- Open the password-protected Excel file.
- Press “Alt + F11” to open the Visual Basic Editor.
- Click on “Insert” and select “Module”.
- Copy and paste the following VBA code:
- Press “F5” to run the code.
- The code will attempt to break the password protection of the Excel file.
- If the password is successfully broken, a message box will appear with the password.
- Use the password to unlock the 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 = 97 To 99: For j = 97 To 99: For k = 97 To 99 For l = 97 To 99: For m = 97 To 99: For i1 = 97 To 99 For i2 = 97 To 99: For i3 = 97 To 99: For i4 = 97 To 99 For i5 = 97 To 99: For i6 = 97 To 99: 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
Cara Membuka Password File Excel Yang Terproteksi
Another method that you can try to unlock your Excel file is by using a third-party software. There are many third-party software available that can help you to unlock password-protected Excel files. One of the popular software is Passper for Excel. Here’s how to use Passper for Excel:
- Download and install Passper for Excel on your computer.
- Launch Passper for Excel and click on “Recover Passwords”.
- Click on “Add” to upload the password-protected Excel file.
- Select one of the three attack modes – dictionary attack, mask attack, and brute force attack.
- If you choose dictionary attack, you need to import a dictionary file. If you choose mask attack, you need to set the password length and other parameters. If you choose brute force attack, you need to set the character set and password length.
- Click on “Start” to begin the password recovery process.
- Once the password is recovered, use it to unlock the Excel file.
Cara Membuka File Excel yang Terkunci Tanpa Aplikasi • Inwepo
If you want to unlock a protected Excel file without installing any software or using any online tool, you can try to use Google Sheets. Here’s how:
- Open Google Sheets on your browser.
- Click on “File” and select “Import”.
- Click on “Upload” and upload the password-protected Excel file.
- Select “Replace current spreadsheet” and click on “Import data”.
- Google Sheets will import the data from your Excel file.
- Click on “File” and select “Download” and select “Microsoft Excel (.xlsx)” to download the file to your computer.
- The downloaded file will be an unlocked version of the Excel file.
FAQ
1. What should I do if none of the above methods work to unlock my Excel file?
If none of the above methods work to unlock your Excel file, you may need to seek professional help. There are many companies that provide password recovery services for a fee. You can do a quick search online to find companies that offer these services.
2. Can I use the same methods to unlock password-protected Word documents?
The methods that are discussed in this article are specifically for Excel files. However, some of the methods may work for Word documents as well. It’s best to do some research and find out the specific methods that are available for Word documents.
Video Tutorial
Here’s a video tutorial that explains how to unlock password-protected Excel files:
Unlocking password-protected Excel files can be a challenging task, but with the right methods and tools, it can be done. Remember to always keep your passwords safe and secure, and avoid using easy-to-guess passwords.