How to Remove an Excel Spreadsheet Password in 6 Easy Steps.
This post we show how to remove an Excel spreadsheet password in 6 easy to follow steps. It is an update to an earlier article where we discussed how you may be able to unprotect an Excel spreadsheet if you have forgotten the password used to protect it. Click here to read that article.
Unfortunately, there is no way that we can view or recover what your lost password is. However, what can be done is remove the password protection from your worksheets, so you once again have full unrestricted access to your data and information.
How to remove a password from a protected Excel worksheet.
It will look something like:
<sheetProtection algorithmName=”SHA-512″ hashValue=”x9RyFM+j9H4J3IFFhsHo3q1kQkuLydpJlLh2mdvfvk15He/Yps8xizWt/XkAJ//g+TyqgcU+8o1QBjQvKDqIzg==” saltValue=”57YXDPnVjawU5s1nGyT8fQ==” spinCount=”100000″ sheet=”1″ objects=”1″ scenarios=”1″/>
Nb: the hashvalue and saltvalue WILL be different in your file than what is shown here.
Select this entire line – everything between and including the “<” and “>” characters and delete it.
(To add your modified files back into your Zip file – ensure you have 7-Zip still open and navigate your way through to where the xml files are stored – i.e. go to the xl folder and then the worksheets folder. Then from your desktop (or wherever you have the modified xml files stored), select ALL your xml files and left click (and hold) and drag and drop the files from the desktop over into the 7-Zip folder.)
Continue the Discussion
Have you had to remove the password from a protected worksheet? If so, how do you do it? Did you use a similar method to the above or another method? Continue the discussion and add your thoughts in the comments section at the bottom of this article.
If you liked this article or know someone who could benefit from this information, please feel free to share it with your friends and colleagues and spread the word on Facebook, Twitter and/or Linkedin.