Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

If you forget the password of the workbook or worksheet, is there an alternative way to open it?

A workbook / worksheet was saved with a password, but unfortunately you forgot about it, are there softwares or any other ways of opening it?

user-image
Question added by Mike Emerson Pasaron , Safety Officer , Arabian Petrochemical Co. (PETROKEMYA)
Date Posted: 2013/06/18
Lubna Al-Sharif
by Lubna Al-Sharif , Medical Laboratory Technician , Nablus Specailized Hospital

=== You can try one of the following solutions to reopen your Excel worksheet again: ==A- Password Variation: -- in case of incorrect password typing (due to CAPS LOCK turned on) or you remember the approximate appearance of the password but fails to recall it in detail, -- you have to take the approximate password and test every possible variant, such as case changes (password -> PASSWORD, Password, PAssword, pASSWORD etc), omission of one of the characters, doubling characters, inserting or replacing the character with the neighboring characters and so on.
-- Usually the number of combinations is not very large and it is possible to test them all in a little time.
==B- "Fake" Password Creation -- By creating a "fake password", that is different from the original one (and it usually looks quite odd), but it can be used instead of the original password.
-- You can use it to remove the protection from the document or to change the existing password.
-- Unfortunately, you can’t determine the original password this way (the only exception is the case when the password is very short and some additional conditions are met).
-- If you have several documents protected with the same password, you’ll be able to use the same fake password to unlock all of them.
-- The fake password is likely to contain very exotic character combinations and if you make a mistake typing it you won’t be able to use it.
Therefore, fake passwords should be typed very accurately (better use the clipboard).
== C- Password Recovery software are based on: -a- Lost password recovery for protected Excel spreadsheet files -b- Crack or decrypt the lost or forgotten Excel passwords by using several algorithmic methods, such as Brute-force attack, Mask attack or Dictionary attack .
-c- Unlock password-encrypted Microsoft Excel documents quickly as possible to get100% recovery rate and allows you to reset "open", "write", workbook, shared workbook and worksheet passwords.
== some examples on those recovery software are: -1)- Excel Password Recovery: protected Excel spreadsheet files (*.xls, *.xlsx) created in Recover forgotten passwords for MS Office Excel97-2007 files.
-2)- Excel Password Recovery Master is used to decrypt password-protected documents created in MS Excel97 -2010 (*.xls, *.xlt, *.xla, *.xlsx, *.xlsm, *.xltx, *.xltm files).
The program -3)- PDS Excel Unlocker software supports forgotten password MS Excel (xls & xlsx) spreadsheets with Excel97 -2010 versions).
-4)- Excel Remove Sheet & Workbook Password Protection Software7.0: this is developed by Sobolsoft , to remove password protection in one or many MS Excel files and does not remove VBA passwords or passwords required when opening an Excel file.
this software supports Excel2000 or higher versions.
-5)- Microsoft Excel Protection Remover1.0: developed by WeBBusterZ Engineering Software, to remove protection password from Microsoft excel worksheets as well as Passwords been created with "Protect sheet" and "Protect workbook" commands.
This software will work with both .xls and .xlsx file extensions and support excel files created with excel97,2003 (.xls) and excel2007,2010 ( .xlsx ), but will not remove VBA password protection from files.
-6)- Remove VBA Password Standart Edition26: developed by Dombaj Soft in Security & Privacy, to remove VBA Password instantly and unlock locked VBA projects in MS Excel, Word, PowerPoint, Access, Publisher, Outlook, FrontPage and Project files.This software supports Office97 to2007 file formats of all supported VBA host applications.
-7)- Guaranteed Recovery was developed by LastBit Corp.
in1999: + to recover any documents in an acceptable amount of time no matter how long the password is.
+ LastBit Corp.
was the first company to offer the solution for guaranteed recovery of password protected Word and Excel documents.
+ While in2004, it we developed an improved technology called Express Recovery that reduced the time required to2 minutes.
+ the Express Recovery can recover Office XP,2003 documents only if they were saved in the default (Office97/2000 compatible) encryption mode.
I hope that these data will be useful

Deleted user
by Deleted user

There is no official password recovery provided by Microsoft if you happen to forget it.
However there are third party MS Office password recovery programs which you can try at your own risk.

charles fagbohun
by charles fagbohun , Senior IT manager , Stoneworks industries ltd

You can use the MS Office password recovery tool, it can automatically find your forgotten password for protected Office Word doc, Excel, PowerPoint etc.
the Microsoft Office2000 -2010 are all supported

Deleted user
by Deleted user

There is always a way, and would be nice to know the version of the Office package you are using.2003?2007?20010? So we can come out with more specific and proper solution, and eliminate the uncompatable solutions for that issue for the purpose of faster and effective solution.

Kaamila Tahseen
by Kaamila Tahseen , Change Management Team Manager , cognizant technology solutions

How to Unprotect an excel sheet without password Unprotect Password Protected Sheet in Seconds In case of a password protect worksheet you are unable to Edit the data on the Excel Sheet.
If you do not Remember the Password or do not know the password to unprotect the sheet just follow the below simple steps.
Press ALT + F11 or click on View Code in Developers Tabs In the Above White Space Enter the below Code.
Do not change the code just copy paste: 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 To66: For j =65 To66: For k =65 To66 For l =65 To66: For m =65 To66: For i1 =65 To66 For i2 =65 To66: For i3 =65 To66: For i4 =65 To66 For i5 =65 To66: For i6 =65 To66: For n =32 To126 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 Now Click on the Run Button or press F5: And there you go the sheet is unprotected for you now.
Also you would be getting a message in the pop up window.

Deleted user
by Deleted user

you can use password recovery program

edwini hsan
by edwini hsan , IT , Excel

Yes surely you can re-open Excel file with Excel password recovery software which rapidly recuperate Excel password. This software is excellent alternative way to re-access Excel file.Visit here to get more:-http://www.excelpasswordrecoverysoftware.org/

jesun thoms
by jesun thoms , EML To MSG , eSoftTools Software

Commonly this happens clients overlooked their Excel document password while insurance time. So particularly for those, clients we are giving the excellent eSoftTools Excel Unlocker Tool that effortlessly filters the entire Excel document and haul out the correct password. Regardless of whether the password to uncommon characters, numeric, alphabetic. It Support all excel version upto 2019.

Read More:- Excel Password unlocker 

With the aid of PDS Excel Password Unlocker Tool user can remove Excel spreadsheet protection password and unlock Excel spreadsheet password. This tool has two types of methods “Dictionary or Brute Force Attacks” to read MS Excel file password. Software recovers all kind of password alphabetic, numerical, symbolic and special-characters of Excel worksheet password.

Get up to% discount on all Password Recovery software and this offer valid till January.

 

 

 

jennifer wingeet wingeet
by jennifer wingeet wingeet , data recovery , Stella Data Recovery

Hove you lost excel file password and you think how to unlock excel file password then try Stella excel password recovery software that has sharp method to recover excel file password and allows open password protection from excel file database. It also support such version of excel file like as:- 97/98/2000/2003/2007/2010/2013 and 2016.

Download this app from here:- https://gallery.technet.microsoft.com/Stella-Excel-File-Password-e731e2fc

To unlock Excel workbook successfully, download eSoftTools Excel password unlocker software. By using its amazing Excel password recovery tool users can also break password security from MS Word and MS Access files. For all Excel versions, users can opt this application.

 

Read More

https://excelpasswordbreaker.wordpress.com/

More Questions Like This