[Music]
hi today I'm going to show you how to
remove the password from an excel file
however the method that we will use
won't work on an encrypted file to start
you would also require windra which is a
compression utility let me open this
demo file as you can see there is a
password and it's not allowing me to
edit the cells of this sheet let's close
it and go to start menu to search for
windra open it and track your excel file
on the open window window as soon as you
dropped it
you will see three folders listed go
into Excel folder and then going to
worksheet folder you would see a file
called sheet 1 dot XML now depending
upon the number of sheets you have in
the workbook there might be more than
one XML file drag out the XML files into
the original folder
right click on the XML file and click
open with no pattern in the notepad
window press ctrl + the letter F to find
for the letter protect you would see
there is a chi which starts with sheep
protection select the entire tag and
delete it
you need to do this on all the XML files
if you had more than one go to file menu
and save the XML document open the
window window from the background and
drag the XML file on the window window
select the compression Methodist store
and click OK close the window window and
delete the XML files now go ahead and
open the original excel file and there
you have it there is no password on it
this method works on Excel 2016 and 2017
the old brute-force method does not work
anymore on the newer versions of Excel
that's it thank you very much for
watching make sure you hit thumbs up if
you have liked it and thumbs down if you
think it sucked please subscribe if you
think I helped you I appreciate your
time bye