{"id":4436,"date":"2016-12-21T07:01:15","date_gmt":"2016-12-21T07:01:15","guid":{"rendered":"http:\/\/www.isunshare.com\/blog\/?p=4436"},"modified":"2023-04-13T08:44:00","modified_gmt":"2023-04-13T08:44:00","slug":"remove-workbook-protection-excel-2010-without-password","status":"publish","type":"post","link":"https:\/\/www.isunshare.com\/blog\/remove-workbook-protection-excel-2010-without-password\/","title":{"rendered":"How to Remove Workbook Protection Excel 2010 without Password"},"content":{"rendered":"<p><span style=\"color: #1c687a;\"><em>&#8220;I have a workbook 2010 that is password protected but I forgot excel password to open and edit. Do you know which way I could use to <strong>remove workbook protection<\/strong> to make it unprotected?&#8221;<\/em><\/span><\/p>\n<ol>\n<li>If forgot excel password to open, I think you would need to remove workbook open password protection.<\/li>\n<li>If forgot excel password to edit, you would probably have to remove read-only password, workbook structure\/windows password and sheet protection password at the same time.<\/li>\n<\/ol>\n<p>So let\u2019s discuss the problem in two parts in order to <strong>remove workbook protection Excel 2010 without password\u00a0<\/strong>effectively.<\/p>\n<ul>\n<li><a href=\"#part1\">Part 1: Remove Workbook open protection<\/a><\/li>\n<li><a href=\"#part2\">Part 2: Remove Workbook edit\u00a0protection<\/a><\/li>\n<\/ul>\n<h2 id=\"part1\">Part 1: Remove Workbook Protection to Open<\/h2>\n<p>If you forgot password to open excel 2010 workbook, you can choose the general way to recover forgotten open password with\u00a0<a href=\"https:\/\/www.isunshare.com\/excel-password-recovery.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>iSunshare Excel Password Genius<\/strong><\/a> at first, and then remove it manually after opening workbook in MS Excel. So that Excel workbook open protection can be removed.<\/p>\n<p><strong>Step 1: Recover Excel Workbook open password.<\/strong><\/p>\n<ol>\n<li>Get <strong>Excel Password Genius<\/strong> full version to install and run on your computer.<\/li>\n<li>Drag protected Excel workbook (xls\/xlsx) into software with &#8220;<strong>Open<\/strong>&#8221; button.<\/li>\n<li>Select right excel open password recovery method from &#8220;<strong>Type of attack<\/strong>&#8221; and set it in details.\u00a0<a href=\"https:\/\/www.isunshare.com\/office-password\/password-recovery-attack-settings.html\" target=\"_blank\" rel=\"noopener noreferrer\">See how to set password attack method<\/a><\/li>\n<li>Recover open password for excel workbook successfully after you click &#8220;<strong>Start<\/strong>&#8221; button.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/recover-excel-workbook-open-password.png\" rel=\"attachment wp-att-4459\"><img loading=\"lazy\" decoding=\"async\" width=\"622\" height=\"575\" class=\"alignnone wp-image-4459 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/recover-excel-workbook-open-password.png\" alt=\"recover excel workbook open password\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/recover-excel-workbook-open-password.png 622w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/recover-excel-workbook-open-password-300x277.png 300w\" sizes=\"auto, (max-width: 622px) 100vw, 622px\" \/><\/a><\/p>\n<p><strong>Step 2: Remove Workbook open password in MS Excel.<\/strong><\/p>\n<p>1. Tap on <strong>Copy<\/strong> and <strong>Open<\/strong> button after a dialog appears with workbook open password.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/copy-excel-workbook-open-password.png\" rel=\"attachment wp-att-4463\"><img loading=\"lazy\" decoding=\"async\" width=\"481\" height=\"360\" class=\"alignnone wp-image-4463 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/copy-excel-workbook-open-password.png\" alt=\"copy excel workbook open password\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/copy-excel-workbook-open-password.png 481w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/copy-excel-workbook-open-password-300x225.png 300w\" sizes=\"auto, (max-width: 481px) 100vw, 481px\" \/><\/a><\/p>\n<p>2. Paste the password and press Enter to open Excel workbook successfully in MS Excel.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/open-password-protected-excel-workbook-2010.png\" rel=\"attachment wp-att-4464\"><img loading=\"lazy\" decoding=\"async\" width=\"279\" height=\"130\" class=\"alignnone wp-image-4464 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/open-password-protected-excel-workbook-2010.png\" alt=\"open password protected excel workbook 2010\" \/><\/a><\/p>\n<p>Now there would be a question about modify password. If excel workbook is also protected with modify password, you will be asked to enter it when opening excel workbook. Otherwise, you just could open workbook in read-only mode.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/open-workbook-2010-in-read-only-mode.png\" rel=\"attachment wp-att-4465\"><img loading=\"lazy\" decoding=\"async\" width=\"279\" height=\"162\" class=\"alignnone wp-image-4465 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/open-workbook-2010-in-read-only-mode.png\" alt=\"open protected workbook 2010 in read-only mode\" \/><\/a><\/p>\n<p>3. Click &#8220;<strong>Protect Workbook &gt; Encrypt with Password<\/strong>&#8221; and clear workbook open password in following &#8220;<strong>Encrypt Document<\/strong>&#8221; dialog.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/remove-workbook-open-password-protection.png\" rel=\"attachment wp-att-4466\"><img loading=\"lazy\" decoding=\"async\" width=\"330\" height=\"206\" class=\"alignnone wp-image-4466 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/remove-workbook-open-password-protection.png\" alt=\"remove workbook open password protection\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/remove-workbook-open-password-protection.png 330w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/remove-workbook-open-password-protection-300x187.png 300w\" sizes=\"auto, (max-width: 330px) 100vw, 330px\" \/><\/a><\/p>\n<p>4. Save the changes to make sure <strong>Workbook open protection remove<\/strong>.<\/p>\n<p><strong>Tips:<\/strong> At this moment, if your Excel Workbook has been opened in read-only mode, it would prevent you to saving any changes in it, unless you agree to save it as a new copy of workbook and then use it. For example, when you try to save changes and get a prompting message, just click <strong>OK<\/strong> and give the workbook a new name in &#8220;<strong>Save as<\/strong>&#8221; dialog. Then both open and modify password would be removed from workbook at the same time.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/save-changes-to-remove-workbook-open-protection.png\" rel=\"attachment wp-att-4468\"><img loading=\"lazy\" decoding=\"async\" width=\"625\" height=\"243\" class=\"alignnone wp-image-4468 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/save-changes-to-remove-workbook-open-protection.png\" alt=\"save changes to remove workbook open protection\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/save-changes-to-remove-workbook-open-protection.png 625w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/save-changes-to-remove-workbook-open-protection-300x117.png 300w\" sizes=\"auto, (max-width: 625px) 100vw, 625px\" \/><\/a><\/p>\n<p>You have <strong>removed workbook open protection<\/strong>, so you could open the workbook without password from now on.<\/p>\n<p>&nbsp;<\/p>\n<h2 id=\"part2\">Part 2: Remove Workbook Protection to Modify<\/h2>\n<p>Believe you have known how to remove workbook protection to modify excel file when you remember the password. But whether you can do that after excel password forgot? If not, now an effective utility is recommended for you on workbook protection removal.<\/p>\n<p><strong>First, get workbook protection removal software to install and launch.<\/strong><\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/workbook-unprotect-genius.html\" target=\"_blank\" rel=\"noopener noreferrer\">iSunshare Workbook Unprotect Genius<\/a> is the fast workbook unprotect utility we recommend to <strong>remove workbook protection excel 2010 without password<\/strong>. Just find its full version and install and run it on your computer, which will<strong> remove edit protection from excel workbook<\/strong> in xlsx format in one click.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/launch-workbook-protection-removal-utility-1.png\" rel=\"attachment wp-att-4474\"><img loading=\"lazy\" decoding=\"async\" width=\"493\" height=\"338\" class=\"alignnone wp-image-4474 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/launch-workbook-protection-removal-utility-1.png\" alt=\"launch workbook protection removal utility\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/launch-workbook-protection-removal-utility-1.png 493w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/launch-workbook-protection-removal-utility-1-300x206.png 300w\" sizes=\"auto, (max-width: 493px) 100vw, 493px\" \/><\/a><\/p>\n<p><strong>Second, add protected excel workbook with &#8220;Open&#8221; button.<\/strong><\/p>\n<p>Make sure excel workbook is only restricted editing by password, such as modify password, sheet protection password and workbook structure protection password etc. If it isn\u2019t, please <a href=\"#part1\"><strong>remove workbook open protection<\/strong><\/a> at first. And then click &#8220;<strong>Open<\/strong>&#8221; button on Workbook Unprotect Genius to import edit-restricted excel workbook.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/add-protected-excel-workbook-2010.png\" rel=\"attachment wp-att-4475\"><img loading=\"lazy\" decoding=\"async\" width=\"493\" height=\"338\" class=\"alignnone wp-image-4475 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/add-protected-excel-workbook-2010.png\" alt=\"add protected excel workbook 2010\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/add-protected-excel-workbook-2010.png 493w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/add-protected-excel-workbook-2010-300x206.png 300w\" sizes=\"auto, (max-width: 493px) 100vw, 493px\" \/><\/a><\/p>\n<p><strong>Third, remove workbook edit protection by &#8220;Remove Passw<\/strong><strong>ord&#8221; button.<\/strong><\/p>\n<p>Once &#8220;<strong>Remove Password<\/strong>&#8221; button is clicked, all sheet protection, workbook structure\/windows protection and modify password would be removed at once.<\/p>\n<p><a href=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/remove-workbook-edit-protection.png\" rel=\"attachment wp-att-4476\"><img loading=\"lazy\" decoding=\"async\" width=\"493\" height=\"338\" class=\"alignnone wp-image-4476 size-full\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/remove-workbook-edit-protection.png\" alt=\"successfully remove workbook edit protection\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/remove-workbook-edit-protection.png 493w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2016\/12\/remove-workbook-edit-protection-300x206.png 300w\" sizes=\"auto, (max-width: 493px) 100vw, 493px\" \/><\/a><\/p>\n<p>If you have tried <strong>Workbook Unprotect Genius<\/strong>, you would find it is just the way you need when you want to remove edit restrictions from excel workbook and it works when workbook has no open password or open password has been removed.<\/p>\n<p><strong>Related Articles:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.isunshare.com\/excel-password\/remove-and-bypass-excel-sheet-protection-password.html\" target=\"_blank\" rel=\"noopener noreferrer\">Remove and Bypass Sheet Protection Password on Workbook<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/excel-password\/how-to-unprotect-excel-workbook-without-password.html\" target=\"_blank\" rel=\"noopener noreferrer\">How to Unprotect Excel Workbook without Password<\/a><\/li>\n<li><a href=\"https:\/\/www.isunshare.com\/blog\/set-excel-workbook-read-only-to-restrict-changes\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Set Excel Workbook Read Only to Restrict Changes<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;I have a workbook 2010 that is password protected but I forgot excel password to open and edit&#8230;.<\/p>\n","protected":false},"author":1,"featured_media":126198,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-4436","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\/4436","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=4436"}],"version-history":[{"count":5,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/4436\/revisions"}],"predecessor-version":[{"id":6447,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/4436\/revisions\/6447"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media\/126198"}],"wp:attachment":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media?parent=4436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/categories?post=4436"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/tags?post=4436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}