Welcome!

By registering with us, you'll be able to discuss, share and private message with other members of our community.

SignUp Now!

Help Help - Excel File is Protected

jayar2022

Apprentice
Feb 10, 2022
33
6
23
♂️
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




1.jpg
 
Anong Excel version ng isave ang file? Hindi ka nag-attach ng file para masubukan pag open.
 
I tried creating a password protected file, then tried to unlock it. I cannot, because it is encrypted.
 
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.
turn excel to zip


  • 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.
extract files


  • 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.
delete sheet protection


  • 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.
 

Similar Threads

What's Trending

Back
Top