Question: How to unprotect an EXCEL 2010 Workbook?
I protect a workbook in Excel 2010 with a password. I have the password, but now I forgot the Excel password and I can't figure out how to unprotect. The option is not there on the review toolbar. It's grayed out as protect. So where do I go to unprotect? I tried to go to File, that doesn't work. How to unlock password Microsoft Excel quickly? I've tried selecting all worksheets first and that doesn't help. I'm at a loss and need to edit this file asap! Thank you!
Answer 1: Forgot xls password is not the end of the world. Not sure about 2010 but suspect it's the same/similar to 2007.
1. Open the Workbook with PW
2. Select <Save As> towards the bottom of the save as screen see <Tools> (to the left of Cancel Save buttons)
3. Use the drop down arrow of Tools <General Options>
4. You should now see 2 fields - Password to Open & Password to Modify (they will have a number of Bullets in one or both entries).
5. Delete them and click OK then <Save> as same/diff name (up to you but I suggest diff name first time you try it to be safe) - You will now be able to Open the Unprotected file.
Hope this helps.
Answer 2: To unlock Microsoft Excel 2010 password when you lost Excel password carelessly, you can make use of SmartKey MS Excel Password Recovery 5.0 without any doubts. It is an excellent Excel 2010 password recovery tool and it supports almost all Excel versions including the latest Excel 2013.
SmartKey Excel Password Recovery is a professional Excel password remover or recovery program designed to recover forgotten passwords for MS Excel 97/2000/XP/2003/2007/2010/2013. It offers three powerful attack types: Brute-Force Attack, Brute-force with Mask Attack and Dictionary Attack. It’s highly-optimized to recover strong passwords at high-speed and use less CPU and memory resources. For example to remove Excel password you can follow the next steps.
Step 1: Download it and click “Open” to load Excel spreadsheet. Select your Excel document in its target folder, then click “Open” to finish file adding.Step 2.Select “100% instant document decryption” and click “Next” to proceed.
Step 3.Click “Decrypt document” to start to remove Excel password instantly.
Step 4.Quickly remove Excel password with receiving the message “The file decrypt successfully”. Then just click “OK” to end password decryption process.
By the way, SmartKey Office Password Recovery is also an excellent Office tool related to Excel. If you need to know how to unlock locked Office password of 2010 easily? It is you good Office 2010 password recovery helper.
Source: http://www.rarpasswordunlocker.net/unlock-excel-2010-password.html