{"id":207,"date":"2013-06-26T08:52:18","date_gmt":"2013-06-26T08:52:18","guid":{"rendered":"http:\/\/www.isunshare.com\/blog\/?p=207"},"modified":"2023-04-18T07:54:07","modified_gmt":"2023-04-18T07:54:07","slug":"unlock-excel-sheet-free","status":"publish","type":"post","link":"https:\/\/www.isunshare.com\/blog\/unlock-excel-sheet-free\/","title":{"rendered":"How to Unlock Excel Sheet Free &#8211; Macro\/XML"},"content":{"rendered":"<p align=\"left\">Locked out of encrypted Excel spreadsheet? Actually<strong><a href=\"https:\/\/www.isunshare.com\/blog\/unlock-excel-sheet-free\/\"> unlock password protected Excel\u00a0sheet<\/a><\/strong>\u00a0is not difficult if you can find password, but it is not\u00a0so easy as you think if you forgot excel spreadsheet password.<\/p>\n<p align=\"left\">Now in this article, I will list two methods that could free unlock encrypted excel sheets without knowing password. They are used usually when people cannot find password protection on excel spreadsheet.<\/p>\n<ul>\n<li><a href=\"#opt1\">Unlock encrypted Excel 2000\/2003\u00a0spreadsheet: Macro<\/a><\/li>\n<li><a href=\"#opt2\">Remove Password Protection from Excel 2007-2016 Spreadsheet: XML File<\/a><\/li>\n<\/ul>\n<h2 id=\"opt1\">1. Unlock encrypted Excel 2000\/2003\u00a0spreadsheet: Macro Command<\/h2>\n<p align=\"left\">Create a Macro in Excel is an option to <strong>unlock password protected Excel sheet<\/strong>. Users can unprotect Excel sheets with a simple syntax. And it can be done through the visual basic editor of Excel.<\/p>\n<p align=\"left\">After unlocking, all the official calculations and tasks can easily be performed. This option will help the user to maintain privacy.<\/p>\n<h3 align=\"left\">Steps:<\/h3>\n<p align=\"left\"><strong>1.\u00a0<\/strong>Open the password protected Excel sheet and enter Macros.<br \/>\nIf you are using Excel 2007, the step could be changed to <strong><em>View-&gt; Macros<\/em><\/strong>.<\/p>\n<p align=\"left\"><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2013\/06\/enter-excel-macro.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1814\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2013\/06\/enter-excel-macro.png\" alt=\"enter-excel-macro\" width=\"650\" height=\"119\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2013\/06\/enter-excel-macro.png 650w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2013\/06\/enter-excel-macro-300x54.png 300w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/a><\/p>\n<p align=\"left\"><strong>2.\u00a0<\/strong>Click on the <strong><em>Record Macro-&gt;OK\u00a0<\/em><\/strong>and next click <strong><em>Stop Recording<\/em><\/strong>\u00a0from the same menu.<\/p>\n<p align=\"left\"><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2013\/06\/record-excel-macro.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1815\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2013\/06\/record-excel-macro.png\" alt=\"record-excel-macro\" width=\"357\" height=\"293\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2013\/06\/record-excel-macro.png 357w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2013\/06\/record-excel-macro-300x246.png 300w\" sizes=\"auto, (max-width: 357px) 100vw, 357px\" \/><\/a><\/p>\n<p align=\"left\"><strong>3.\u00a0<\/strong>Enter <strong><em>View Macros<\/em><\/strong>\u00a0and you will find a Macro with a default name E.g. <strong>Macro1<\/strong>. Select the macro name and click on <strong>Edit<\/strong>.<\/p>\n<p align=\"left\"><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2013\/06\/edit-excel-macro.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1816\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2013\/06\/edit-excel-macro.png\" alt=\"edit-excel-macro\" width=\"383\" height=\"366\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2013\/06\/edit-excel-macro.png 383w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2013\/06\/edit-excel-macro-300x286.png 300w\" sizes=\"auto, (max-width: 383px) 100vw, 383px\" \/><\/a><\/p>\n<p align=\"left\"><strong>4.\u00a0<\/strong>Now a Visual Basic Editor opens up, replace the default code and paste the following code.<\/p>\n<p align=\"left\"><strong>The code is written with syntax\uff1a<\/strong><br \/>\nActiveSheet.Unprotect (&#8220;MyPassWord&#8221;)<br \/>\n&#8216;instructions<br \/>\nActiveSheet.Protect (&#8220;MyPassWord&#8221;)<\/p>\n<p align=\"left\">For more details, I suggest you type &#8220;worksheet.protect&#8221; and &#8220;worksheet.unprotect&#8221; in the help file of visual basic editor.<\/p>\n<p align=\"left\"><strong>Also try this syntax:<\/strong><\/p>\n<p>ActiveSheet.Protect PassWord:=\u201dMyPassWord\u201d, DrawingObjects:=True,<br \/>\nContents:=True, Scenarios:=True, AllowSorting:=True, AllowFiltering:=True, AllowUsingPivotTables:=True<\/p>\n<p align=\"left\"><strong>5.\u00a0<\/strong>Click <strong>View -&gt; Macro\u00a0-&gt; View Macros -&gt; Run<\/strong>.<\/p>\n<p align=\"left\"><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2013\/06\/run-excel-macro.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1817\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2013\/06\/run-excel-macro.png\" alt=\"run-excel-macro\" width=\"384\" height=\"367\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2013\/06\/run-excel-macro.png 384w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2013\/06\/run-excel-macro-300x286.png 300w\" sizes=\"auto, (max-width: 384px) 100vw, 384px\" \/><\/a><\/p>\n<p align=\"left\">At last you will get the password of the protected Excel spreadsheet.\u00a0Copy it and unprotect excel sheet. This has been tested in Microsoft Excel 2003 and 2007.<\/p>\n<h2 id=\"opt2\">2. Remove Password Protection from Excel 2007\/2010\/2013\/2016 &#8211; XML File<\/h2>\n<p align=\"left\">Since Microsoft Office 2007 is released, the Excel file type has included .xlsx, .xlsm, xltx, etc. The new file are essentially packages that contain <a href=\"https:\/\/www.isunshare.com\/blog\/create-open-office-xml-file\/\">XML files<\/a>. Therefore, if you take an XLSX\u00a0file and change the extension to zip, you&#8217;ll be able to see all the xml documents that make up your Excel file. You can <strong>remove spreadsheet protection<\/strong> simply by applying a simple edit to the xml within the Excel file.<\/p>\n<h3 align=\"left\">Steps:<\/h3>\n<p align=\"left\"><strong>1.\u00a0<\/strong>Make a backup of excel file.<\/p>\n<p align=\"left\">The backup promises to keep the original Excel file even though you fail to remove Excel file password with this method. And then you could try another way to unlock encrypted spreadsheet.<\/p>\n<p align=\"left\"><strong>2.\u00a0<\/strong>Change excel file type to <strong>zip file<\/strong>.<\/p>\n<p align=\"left\"><strong>3.\u00a0<\/strong>Extract the contents of the zip file.<\/p>\n<p align=\"left\"><strong>4.\u00a0<\/strong>Find <strong>xml file<\/strong> in the zip extraction file and open xml file (found in the <strong>&#8216;xl\\worksheets<\/strong>&#8216; directory).<\/p>\n<p align=\"left\">Open the target sheet&#8217;s xml document using an XML editor (For example, <strong>XML Marker<\/strong>).<\/p>\n<p align=\"left\"><strong>5.\u00a0<\/strong>Find the &#8216;<strong>sheetProtection<\/strong>&#8216; tag and remove the entire line.<\/p>\n<p align=\"left\"><strong>6.\u00a0<\/strong>Save the edited xml file and replace the old xml file in the original zip file.<\/p>\n<p align=\"left\"><strong>7.\u00a0<\/strong>Change the extension back to <strong>.xlsx<\/strong>.<\/p>\n<p align=\"left\">Enjoy your unprotected excel worksheet now.<\/p>\n<p align=\"left\">Besides password protection on excel spreadsheet, open password also could be used usually to protect excel file. If it is excel file open password forgot now, I think you would need to <strong><a href=\"https:\/\/www.isunshare.com\/excel-password\/recover-excel-password.html\">recover Excel file password<\/a>\u00a0<\/strong>with third-party software,\u00a0such as easy-to-use\u00a0<a href=\"https:\/\/www.isunshare.com\/excel-password-recovery.html\">Excel Password Genius<\/a>.<\/p>\n<p align=\"left\"><strong>Related Articles:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.isunshare.com\/excel-password\/unlock-excel-worksheet-without-password.html\" target=\"_blank\" rel=\"noopener\">How to Unlock Encrypted Excel Spreadsheet without Password<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/excel-password\/unprotect-xls-xlsx-worksheet-without-password.html\" target=\"_blank\" rel=\"noopener\">Two Methods to Unprotect XLS\/XLSX Worksheet without Password<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/excel-password\/crack-worksheet-password.html\">Find\u00a0and Get Worksheet Original Password &#8211; Recover Excel Password<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/blog\/open-password-protected-word-document\/\">How to Open Password Protected Word Document<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/blog\/how-to-unlock-word-document-2013-without-password\/\">How to Unlock Word 2013 Document without Password<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/blog\/protect-office-with-password\/\">Protect Office Files with Password &#8211; Set\/Reset Password<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Locked out of encrypted Excel spreadsheet? Actually unlock password protected Excel\u00a0sheet\u00a0is not difficult if you can find password,&#8230;<\/p>\n","protected":false},"author":1,"featured_media":126437,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-207","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office-documents"],"_links":{"self":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/207","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/comments?post=207"}],"version-history":[{"count":5,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/207\/revisions"}],"predecessor-version":[{"id":7055,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/207\/revisions\/7055"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media\/126437"}],"wp:attachment":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media?parent=207"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/categories?post=207"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/tags?post=207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}