Tuesday, March 28, 2017

How To Unlock An Excel File Without Password

How To Unlock An Excel File Without Password
In this Tutorial, I will show you How To Unlock an Excel Sheet Without Password. This will work on all Excel versions (2016, 2013, 2010,...).
In case of a password protected worksheet you are unable to edit the data on it. If you have ever forgotten or you don't know the password to unlock this file, you are just in the right place.
So how do you unprotect an Excel file when you don't have the password? Here is a simple and effective solution:

How To Unprotect an Excel Spreadsheet Without Password.

To unlock an Excel file without password, just follow these steps:
  1. Make sure the Excel file is closed then change the file name extension from .xlsx to .zip. Then click "Yes".
How To Unlock An Excel File Without Password 1

  1. Open the .zip file with 7-zip then go to folder xl-> worksheets.
  2. Open sheet1.xml with Wordpad or NotePad.
  3. Press Ctrl + F, and search for "sheetprotection". 
  4. Delete the entire element that starts from "<sheetProtection" to "/>".
How To Unlock An Excel File Without Password 2

  1. Save the modification and close the file. and Click "Ok" when prompted with a warning dialog.
  2. Change back the .zip to .xlsx
  3. Now your Excel file is UNLOCKED, you can open your file and make any modification without any password.

♥ If you like this Article, Share it, your friends might like it too ♥

0 commentaires:

Post a Comment

Twitter Delicious Facebook Digg Stumbleupon Favorites More