As the world has become global village. People protect their soft form of documents with passwords. But now there are a lot of things to remember in this world. As the time passes, age factor affects and you start forgetting things.
Password is one of the most critical thing that you forget. Another situation is that when you access an old Excel file for reviewing and you came to know that it has been encrypted by its author. There you will be needing password to access that file. If you forgot Excel password 2010 there is a chance to recover that file.
You just need to select one of the below methods and your Excel file will be decrypted in no time. All these steps are safe and secure. Using 7-ZipIf you have forgotten Excel file password and there is no way you could get that password back, here are some steps that could get your document back to you.
It's tricky but not difficult just go step by step. You will be needing 7-Zip software for getting through these steps.1. If your files extensions are not enabled, you have to enable them by navigating to Control Panel Folder option View and disable 'Hide Extensions for known file types'.2.
Now look for your protected Excel file and change its extension from.xlsx to.zip by renaming the file.3. Now open your zip file using 7-zip and navigate to xl worksheets and extract sheet.XML file(s). These sheets represent your Excel files sheets.4. Now open the extracted XML file with notepad or wordpad and find the following tag:'.5. Now select the whole tag and remove it.6. Now save the XML file and put it back in the same zip folder and replace the old one.7. Close the zip file and change the extension back to.xlsx from.zip.This method only applies to password protected workbooks.
Cara Membuka Password Pada Excel 2010
If the file is secured with the 'Encrypt with Password' feature, it will not work. Using VBA CodeVBA code is another way to unprotect Excel file. It is one of the simple method but it has to be done step by step. But first you have keep in mind following points:. If Excel file contain 2 or more protected sheets, run this code for each sheet.
If your Excel document version is later than 2010 then first save the document as Excel 97-2003 workbook (.xls), run the macro, and then save it back to original version.Now follow the following steps:1. Open your Excel file and press Alt + F11 to open the Microsoft Visual Basic for Applications.2. Now Right click on the workbook name and select Insert Module.3. A dialogue box will appear in the right pane. Open PassFab for Excel and to see its main function.
Setelah Excel terbuka, tekan pada Keyboard Alt+F11, akan muncul VBA. Klick VBA Project dan masukan Password: 1 akan terbuka spt ini sekarang VBA sudah bisa. Langkah pertama cara membuka protect sheets excel tanpa password, kelik kanan pada nama sheet file yang ada dibagian bawah (seperti sheet1, sheet2, dan sheet3) lalu pilih “VIEW CODE” atau tekan tombol kombinasi “Alt + F11″ maka akan terbuka jendela Microsoft visual basic kemudian pilih insert MODULE.
In the main interface of it, please click Add option to import your password-protected document.Step 2. When you add your locked file, you'll see the general info of the file: size, last modified date, and password. The next step is to select a password crack type.Step 3.
Once you confirm the attack type, click 'Start' to crack password. The specific time depends on your password length, complexity and computer configuration. If your computer supports GPU, please select GPU Acceleration option before you click 'Start'.Step 4. Once the password is found, a dialog window appears and displays your password. Thus, you can use the password to unlock your file.