Do you ever find yourself needing to access an Excel file that has been password protected? It can be frustrating when you don’t have the password to access important data on the sheet. But fret not, there are ways to overcome this obstacle. In this article, we will provide you with tips and tricks on how to unlock password-protected Excel sheets.
Cara Membuka Excel Yang Di Protect Menghapus proteksi sandi pasword
If you are in a hurry and need quick access to the information on the Excel sheet, you can try removing the password protection altogether. Firstly, open the protected file in Excel.
Next, go to the ‘File’ tab at the top left corner of the Excel screen and click on it. Once the drop-down menu appears, click on the ‘Info’ tab. Here, you will see an option titled ‘Protect Workbook’. Click on it and choose ‘Encrypt with Password.’
Now, in the password box, erase the current password and click ‘OK’. This will remove the password protection from the Excel sheet.
Cara Membuka Password File Excel Yang Terproteksi
If you want to keep the password protection on the Excel sheet but have forgotten the password, there are still ways to access the data on the sheet. There are various tools available online that can help crack the password, but be cautious when downloading and using these tools as they may contain malware or viruses.
If you don’t want to risk downloading a third-party tool, there is another method you can try. Firstly, make a copy of the password-protected file. Then, change the file extension from .xlsx to .zip. This will turn the Excel file into a compressed folder.
Open the compressed folder and navigate to the ‘xl’ folder. Here, you will see a file titled ‘workbook.xml’. Right-click on this file and open it in a text editor like Notepad or Wordpad.
Once you have opened the ‘workbook.xml’ file, search for the tag ‘<sheetProtection’ and delete it. Save the file and close the text editor.
Now, go back to the compressed folder and change the extension back to ‘.xlsx’. The file is now unprotected and you can access the data on the sheet.
Tutorial Cara Membuka File Excel Yang Terkunci Terproteksi
If you are not comfortable with changing the file extension or editing the XML file, you can try using a macro to bypass the password protection.
Firstly, open the password-protected Excel file and press ‘Alt + F11’. This will open the Visual Basic for Applications (VBA) Editor window. Go to ‘Insert’ and click on ‘Module’. In the new module, type the following code:
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
Press ‘F5’ to run the macro. This will generate a usable password that can unlock the Excel sheet. Note that this method can take some time as the macro generates a large number of passwords before finding the correct one.
Cara membuka file Excel yang dikunci / dilindungi (+ gambar)
If none of the above methods work for you or if you are still unsure about trying them out, you can try contacting the person who created the password-protected Excel sheet. They may be able to provide you with the password or unlock the sheet for you.
Alternatively, if the Excel file is stored on a company server, you can contact your IT department for assistance. They may have a special tool or access to the server that can help unlock the Excel sheet.
Cara Membuka Excel Yang Tidak Bisa Diedit / Terproteksi
If you are able to access the Excel file but are unable to edit it, the sheet may be protected by a ‘Sheet Protection’. To remove this protection, go to the ‘Review’ tab on the Excel ribbon and click on ‘Unprotect Sheet’. If prompted for a password, enter the password provided by the creator of the Excel sheet. Once the sheet is unprotected, you can make changes to it.
Another reason why an Excel sheet may be uneditable is due to it being in ‘read-only’ mode. To remove this mode, right-click on the Excel file and go to ‘Properties’. In the ‘General’ tab, uncheck the box titled ‘Read-only’. Click ‘Apply’ and then ‘OK’. The Excel sheet is now editable.
Frequently Asked Questions:
1. Can I use an online tool to remove the password protection from an Excel sheet?
While there are various online tools available to remove password protection from Excel sheets, it is not recommended to use them as they may contain malware or viruses. It is always best to try the manual methods listed above or contact the creator of the Excel sheet for assistance.
2. What should I do if I forget the password to an Excel sheet?
If you forget the password to an Excel sheet, try using one of the manual methods listed above to access the data on the sheet. If all else fails, contact the creator of the Excel sheet for assistance or your company’s IT department if the sheet is stored on a company server.