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
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.
