Have you ever faced a situation where you cannot access an Excel file because it is password protected? Or have you ever accidentally overwritten an important document in Word or Excel, and cannot find a way to recover it? Worry not, as in this article, we will provide you with several solutions to these problems.
Cara Membuka File Excel yang Terkunci Tanpa Aplikasi
It can be frustrating when you forget the password of an important Excel file you have. However, there are several methods that you can use to unlock the file.
Method 1: Using Google Sheets
An easy and hassle-free way to unlock a password-protected Excel file is by using Google Sheets. Follow these steps:
- Open Google Sheets and click on File > Import > Upload.
- Select the password-protected Excel file that you want to unlock from your computer.
- Click on Import Data.
- When asked for the password, leave it blank and click on Sign In.
- You will then have an unlocked version of your Excel file.
Method 2: Using VBA Code
If you have basic knowledge of Excel and its functions, you can use Visual Basic for Applications (VBA) code to unlock the password-protected Excel file. Follow these steps:
- Open the password-protected Excel file.
- Press Alt + F11 to open Visual Basic Editor.
- Click on Insert > Module.
- Paste the following code:
- Press F5 or click on Run > Run Sub/UserForm to execute the code.
- The password of the worksheet will be displayed in a message box.
- Note down the password and use it 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 = 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
Cara Mengembalikan File Document (Excel, Word, PPT) Yang Tertimpa
Accidentally overwriting an important document in Word or Excel can be frustrating. However, there are several methods that you can use to recover the overwritten document.
Method 1: Using AutoRecover
In Word or Excel, AutoRecover automatically saves a temporary copy of the document at regular intervals. Follow these steps to recover the overwritten document:
- Open the Word or Excel application.
- Click on File > Open > Recent Documents/Recent Workbooks.
- Look for the overwritten document and click on it.
- If the document is not there, click on File > Info > Manage Document > Recover Unsaved Document/Recover Unsaved Workbook.
- Look for the temporary copy of the document and open it.
- Save the document with a new name to prevent it from being overwritten again.
Method 2: Using Previous Versions
If you have enabled System Protection in Windows, previous versions of your document are saved as restore points. Follow these steps to recover the overwritten document:
- Right-click on the location where the document was saved.
- Click on Properties > Previous Versions.
- Look for the restore point which precedes the date when you accidentally overwrote the document.
- Click on Restore.
- Open the restored document and save it with a new name to prevent it from being overwritten again.
FAQ
Q: Is there a way to recover an overwritten document if I have not enabled AutoRecover or System Protection?
A: Unfortunately, there is no guaranteed way to recover an overwritten document if you have not enabled any form of backup. However, you can try using third-party software such as Recuva to scan for deleted files and see if the original document or any backup files can be recovered.
Q: Are there any risks involved in using VBA code to unlock a password-protected Excel file?
A: Yes, there are a few risks involved in using VBA code, such as accidentally corrupting the Excel file and potentially losing the data permanently. It is always advisable to make a backup copy of the Excel file before attempting any password-cracking methods.
