Aug 08 2020 04:10 AM - last edited on Nov 09 2023 11:08 AM by
Hi team need support to unprotect my sheet which is password protected and forgot the password
Nov 08 2022 08:19 AM
Nov 08 2022 10:32 AM
Nov 08 2022 10:35 AM
Nov 08 2022 10:41 AM
Nov 09 2022 02:32 AM
Please tell me to how to enter your so many lines code? I forget my password on excel workbook, tried iSeepassword. by rename .zip, none of work. If your method works, I would like to know how to enter those codes. Thank you
Nov 09 2022 02:38 AM
Nov 09 2022 02:44 AM
Nov 09 2022 03:14 AM
Nov 09 2022 03:51 AM
Nov 09 2022 06:58 AM
@cery1999 hi, I am not an expert. I am facing the same problem and am looking for solution.
Nov 10 2022 12:02 PM
@cery1999 No, the file will not be blocked. But decryprion will be unsuccessful and Excel will ask to enter a valid password. All password crackers work following this principle: you set the range to be checked and they check all options from this range using conventional bruteforce searching for the valid password.
This is applied if you set a Password to Open, of course, but not a sheet password or VBA, and this topic is about it. ;)
Nov 10 2022 05:37 PM
@denglad what is your suggestion in my case. I find out that I didn't forget the PW. another file that I open it everyday. Yesterday, I made a copy rename by different date. Today, none of these two files can be opened. I wrote down the pw. and I updated every day. Now, it shut me down. What should I do? Please advise. thank you
Nov 11 2022 09:11 AM
Nov 13 2022 12:43 PM
Nov 13 2022 02:53 PM
@denglad I went to Review, selected Protec Workbook. I entered a password, then confirm the password. I did not select other box. I remember the box of Structure is checked by default.
I did not write down pw. Next time to open with my memory, it told me a wrong pw. I tried many different digits, none of them works. Do you have any idea or suggestion? Please help.
Nov 15 2022 03:22 AM - edited Nov 15 2022 03:25 AM
You can do this without losing your .xlsx features or using an old copy of Excel.
Before you do this take a copy of your file in case it goes wrong.
<sheetProtection password="12345" sheet="1" objects="1" scenarios="1" selectLockedCells="1"/>
6. Save the xml file
7. Zip up again and rename to .xltr
8. Open the file and save as .xlsx
9. Protect the sheet again with a more memorable password ;)
Nov 15 2022 03:56 PM
Thank you Vlad, Why I tried many times by double click .zip, error message: "zip is empty", or "is invalid" I have no way to keep processing. My excel file has 485kb. where I did wrong? Please advise. Thank you
Nov 16 2022 01:28 AM
Nov 16 2022 02:20 AM
Don't forget you can use this procedure to open a locked worksheet (possibly),
but you cannot open a workbook under any circumstances with this procedure.
Caution: If you create a password for a workbook, make a note of the password and keep it in a safe place. If you lose the password, you cannot open or access the password-protected workbook.
Dec 02 2022 06:25 AM