Provides Professional Knowledge about Password Recovery and Product Key

How to unlock Excel file free – Macro/XML

Unlock password protected Excel file is not difficult, but unprotect Excel sheet is not so easy as you think. Now let me tell you two free methods for you to make your Excel file unlocked.

1. Unlock MS Excel (Office) 2007 or lower versions: Macro Command

Create a Macro in Excel is an option to unlock password protected Excel sheet. Users can unprotect Excel sheets with a simple syntax. And it can be done through the visual basic editor of Excel.

After unlocking, all the official calculations and tasks can easily be performed. This option will help the user to maintain privacy.

Step 1: Open the password protected Excel sheet enter Macro’s
If you are using Excel 2007, the step could be changed to View-> Macros.

Step 2: Click on the “Record Macro->OK” and next click “Step Recording” from the same menu.

Step 3: Enter “View Macros” and you will find a Macro with a default name E.g. Macro1. Select the macro name and click on Edit.

Step 4: Now a Visual Basic Editor opens up, replace the default code and paste the following code .

The code is written with syntax:
ActiveSheet.Unprotect (“MyPassWord”)
‘instructions
ActiveSheet.Protect (“MyPassWord”)

For more details, I suggest you type “worksheet.protect” and “worksheet.unprotect” in the help file of visual basic editor.

Also try this syntax:

ActiveSheet.Protect PassWord:=”MyPassWord”, DrawingObjects:=True,
Contents:=True,  Scenarios:=True, AllowSorting:=True, AllowFiltering:=True, AllowUsingPivotTables:=True

Step 5: Click View->Macro->View Macros->Run.

At last you will get the password of the protected Excel document. This has been tested in Microsoft Excel 2003 and 2007.

2. Remove Password Protection on Excel 2007/2010/2013 – XML File

Since Microsoft Office 2007 is released, the file type of Excel has included .xlsx, .xlsm, xltx, etc. The new file types are essentially packages that contain XML files. Therefore, if you take an xlsx file and change the extension to zip, you’ll be able to see all the xml documents that make up your Excel file. You can remove spreadsheet protection simply by applying a simple edit to the xml within the Excel file.

Modify xml file to unprotect Excel workbook or sheet, take Excel sheet as example

Step 1: Make a backup of excel file
The backup promises to keep the original Excel file even though you remove Excel file password unsuccessfully.

Step 2: Change excel file type to zip file

Step 3: Extract the contents of the zip file

Step 4: Find xml file in the zip extraction file and open xml file (found in the ‘xl\worksheets’ directory)
Open the target sheet’s xml document using an XML editor (For example, XML Marker)

Step 5: Find the ‘sheetProtection’ tag and remove the entire line.

Step 6: Save the edited xml file and replace the old xml file in the original zip file.

Step 7: Change the extension back to xlsx.
Enjoy your unprotected sheet now.

Is it a little difficult? If you think so, you also can recover Excel file password with third-party software, for example, Excel Password Genius. It is aim at helping computer newbie to recover password in simplest way. What you should do is just two steps. Press Open button to import Excel file into software, and then Start to recover password.

Related articles:
Crack and Get Worksheet Original Password – Recover Excel Password
Three ways to remove Word password
Recover Office password easily – Excel/Word/Access/Outook/Powerpoint
How to open password protected Word document
Protect Office files with Password – Set/Reset Password

, ,

One Response to “How to unlock Excel file free – Macro/XML”

  • Lesie says:

    Good! Free and effective ways even though it is not easy to do for everyone. It will be perfect if there is a software recovering password.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>