Unlocking Excel files when you forget your password is super simple
Have you 'forgot' the password to protect your Excel file? Find out immediately how to unlock Excel files when you forget your password. TipsMake shares specifically in the article below.
Excel, Word files as well as many other documents allow you to set passwords to protect your personal data. Setting a password and knowing the password to open the file is simple. But sometimes users have 'golden fish brains' so they forget the Excel file password. Therefore, how to unlock Excel files when you forget your password is of interest to many users. Don't worry, TipsMake has researched and has a way to help you 'break the lock' quickly in the next part.
Instructions on how to unlock Excel files when you forget your password very easily
Forgetting a password is no one's business, especially if it's an Excel file you don't open often for a long time. There are many ways to unlock Excel files. You can open locked Excel files that cannot be edited with software or without software. As follows:
Method 1: Open password-locked Excel file online
How to open password-locked Excel files online is used by many people. The advantage of this method is that it quickly and easily breaks the password for Excel files without having to download software. One of the online software that many users trust and choose is LostMyPass. Specifically, you access the website on your computer HERE > Tick the box I am not a robot to verify.
After verification is complete, click or click here to download the Excel file that needs to be unlocked > Wait for the software to unlock and then download the Excel file > Note, after unlocking the file, the system will restore and Display the password of the Excel file in the Recovered password section. You should save this password and can use it to open Excel files.
Method 2: Break Excel password without software using script
To open an Excel file that is locked and cannot be edited, users should open the Excel file containing the Sheet that needs to be unlocked. Then, follow the steps below:
- Step 1: Press the key combination Alt + F11 > When the Microsoft Visual Basic for Applications window displays, the user clicks on the Insert tab > Select Module.
- Step 2: When the white frame appears, copy the paragraph below and paste it.
Sub PasswordBreaker()
If ActiveSheet.ProtectContents = False Then
MsgBox 'Sheet '' & ActiveSheet.Name & '' is unprotected!', vbInformation
Else
If MsgBox('Sheet '' & ActiveSheet.Name & '' is protected, do you want to unprotect it?', _
vbYesNo + vbQuestion, 'Unprotect Active Sheet') = vbNo Then Exit Sub
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)
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
If ActiveSheet.ProtectContents = False Then MsgBox 'Sheet '' & ActiveSheet.Name & '' is unprotected!', vbInformation
EndIf
End Sub
- Step 3: Then, close the window, in the next interface click on the View tab > Click to select Macros.
- Step 4: In the new window, select PasswordBreaker > Then select Run.
- Step 5: When the notification appears, the user clicks Yes > Wait for the unlock to be successful, then click OK. Note, when you open the password, you need to save the file as Save As or save it to another file.
This trick to open a password-locked Excel file only works to unlock the Sheet. If the file is in Protect Read Only mode, you need to remove Protect Read Only to be able to change it.
Above are two ways to unlock Excel files when you forget your password without software. If these methods are not successful, you can refer to unlocking software like iSumsoft Excel Password Refixer to break the lock.
You should read it
- How to unlock iPhone when forgot password
- How to unlock 3-digit suitcase without password
- How to Open Password-Protected Excel Files
- How to Open a Password Protected Excel File
- How to open a computer when forgetting password Windows 10
- How to break Excel Password without software
- How to Copy Secure PDF Files on Windows or Mac Computers
- Instructions to set a password for the Excel file
May be interested
- Forgot iPhone password, what to do?it is often difficult to forget the 4-digit iphone password (passcode) but does not mean it does not happen. if you forget or enter the wrong 6-time passcode on your iphone or ipad, your device will show notifications of disabled (disabled). what should you do in this case?
- Forgot iCloud password? How to get it back super simple!for any apple device using ios operating system, icloud is very important information to manage the device and data. but if you forget your icloud password, how to recover it?
- Instructions for changing Windows passwords without having to remember the old passwordsuppose in case you want to change your windows computer password but forget the old password. or suppose you want to log into a user's computer .... you can easily use the command prompt to change the old password.
- Find password of Word and Excel files with Word and Excel Password Recovery Wizardset passwords for important word or excel documents to help you better protect your documents. but after a period of not using you forgot the password of that document. you can use the software word and excel password recovery wi
- Log in to your computer when you forget your password or break your Windows passwordwhat will you do to log in to windows and forget your password? is there any solution to help you break or remove the previously set password? certainly yes, handling windows login when you forget your password is just one of thousands of other problems on windows 10, 8, 7, and possibly windows 11 that tipsmake has guided readers.
- 5 ways to reset Apple ID passwordforgetting your apple id means you will be locked out of apple devices and services like apple music, icloud, app store, etc. but don't panic if you forget your password because resetting your apple id password is quite simple. simple in most cases.
- Forgetting ATM card password, losing ATM PIN how to get it back?how to get a pin code for an atm card? please read along with the following article of network administrator.
- Crack Excel password, remove Sheet password in Excel filedon't remember your excel password and want to find a way to recover it? learn the trick to easily crack excel password, helping you quickly regain access.
- How to view saved Wifi passwords on Windows 7/8/10forgetting your wi-fi password can quickly become an obstacle, but don't panic. if you have a pc or mac connected to that wireless network, today's article will show you how to retrieve the forgotten password.
- What will you do when you forget your Mac OS X login passwordthe fact that users forget the password to log in to the computer is frequent. and how will they fix this problem? in the following article, tipsmake.com will show you how to retrieve your login password with mac os x operating system