Welcome to Pinoy Tech Forum

[jayar2022]

Sir, a Good day at sa lahat ng may idea nito pa help naman nito na paano ba to ma e ***** na ganitong protected password sa excel kasi iba itong protected na ito parang whole file hindi ko ma configure ito kaysa ibang protcted sheet lang kaysa nito sana meron kaayung idea o tutorial na katulad nito kung paano ba e ***** itong ganitong protected password sa ganitong excel kasi importante na files ito nakalimotan ko na ang password nito at parang naka passwqord sya whole file salamat po. Godbless

 

[maniy]

Anong Excel version ng isave ang file? Hindi ka nag-attach ng file para masubukan pag open.

 

[maniy]

I tried creating a password protected file, then tried to unlock it. I cannot, because it is encrypted.

 

[mskijom]

TRY THIS ONE SOLUTION:

• Create Backup - One of the most important things you have to do even before the procedure begins is to create a backup of the Excel file that is protected with a password.
• Rename File - After having created a backup, you need to rename the file by right-clicking on the excel sheet and clicking on the 'rename' button.
• Change Extension - Whether your file has a .csv extension or a .xls extension, it is time for you to change it to a .zip extension.

• Unzip Content - After having renamed the file and having changed the extension to .zip, it is time to unzip the content from the zip file.
• Search File - Now you need to search for the file that ends with a .xml format.
• Open File - After having found the file with .xml format, click on that file and open it with an XML editor.

• Press 'Ctrl + F' - Pressing the Ctrl button and F together will let you find your desired word. In this case, you are searching for the word 'SheetProtection'. You need to search for it.

• Remove that Word - Once you have found that word, remove it from the file.
• Save File - After removing the word from the file, save it.
• Change Extension - Once you have saved the file, change back the file extension from .zip to .xls or .csv, whichever you prefer or want.