Open password protected Excel-worksheet - lost password

Author: Dinesh Kumar Takyar
241935 View
4m 29s Lenght
87 Rating

Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.comYou can use Google Docs through your Gmail account to open a password protected Excel worksheet whose password you have lost. The process involves the following steps: 1. Create a Gmail account 2. Log into your Gmail account 3. Click on documents 4. Click on upload 5. Google Docs automatically allows you to make changes and saves the file 6. Download the file as an 'Excel' file 7. It is saved as an 'xls' file which means the version 1997 to 2003. 8. We can now 're-save' the file using our Excel 2007 application in the 'xlsx' format http://www.youtube.com/watch?v=aJw9_pTyK0k Attention: Google Docs no longer allows the import or opening of MS-Excel password protected files anymore! Here's another useful link for password recovery: http://www.freeoffice.vbapasswordrecovery.net/ If things fail then also try this VBA procedure: Sub PasswordBreaker() 'Author unknown '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 More details can be found here: http://spreadsheetpage.com/downloads/sheet_password_breaker.txt http://spreadsheetpage.com/index.php/tip/spreadsheet_protection_faq1/

Comments

  1. My file is password protected. I cannot even view my sheet. I have forgotten my password. Let me know your number please. Will be faster chatting.
  2. Used this today with the new Microsoft. IT WORKED :) ! Thanks sooo much! Life saver!
  3. thanks
  4. worked like charm, very easy .. tried several other before ending up here. But it was really worth. A job well done. Didn't work exactly as shown, but all i did was upload and then download again and that's it tada...
  5. thank you
    worked out perfectly
  6. Thanks A lot sir. Its Working and I recovered my file.
  7. Google does not upload files that are password protected not to read. This solution is outdated.
  8. this does not work
  9. Thanks a lot it really helped
  10. Hello Dinesh ,

    Can you help me in recovering a password from binary saved file. It has VBA code as well. I need to recover the passwords and it would be really helpful. Thanks
  11. Sir I know the password but dont have Excel. Any online tool to open it ?
  12. i want to unlock windows 7 xls password help me 
  13. I was pretty irritated that a workbook I saved on a network drive was protected by someone. This worked like a charm.
  14. For me, this didn't work exactly as described, but it did work.  Thank you!  Once uploaded, I was unable to open the document in Google Drive as it was still password protected.  I then downloaded the password protected document from Google Drive to my computer and opened it as an Excel file and it worked!  
  15. There is No "Upload" Option in my Account.Plz..... help Me
  16. nice tutorial i did practical with it,,and it has helped me more
  17. How can I open a 2013 excel file without the password?
  18. hi Mr Dinesh i have  an excel 2007 and i tryed everything to reopen the excel file but i cannot could u please help me to reopen my excel file ....
  19. My excel file was saved excel 2007 ver. I forgot the password. Now I try to open it as per your video instruction it is not opening asking password again.
    please give the solution I am not going to purchase.