{"id":159,"date":"2015-06-29T08:12:41","date_gmt":"2015-06-29T08:12:41","guid":{"rendered":"http:\/\/www.isumsoft.com\/it\/?p=159"},"modified":"2019-11-27T09:22:38","modified_gmt":"2019-11-27T09:22:38","slug":"how-to-protect-excel-workbook-from-opening-and-editing","status":"publish","type":"post","link":"https:\/\/www.isumsoft.com\/it\/how-to-protect-excel-workbook-from-opening-and-editing\/","title":{"rendered":"How to Protect Excel Workbook from Opening and Editing"},"content":{"rendered":"<p>In a study or at work, Microsoft Excel is the most commonly used data handling software. It\u2019s necessary to set a password to protect an Excel workbook that stores important and confidential data. Now from this article, you will learn <strong><a href=\"https:\/\/www.isumsoft.com\/it\/how-to-protect-excel-workbook-from-opening-and-editing\/\">how to protect Excel workbook from Opening and Editing<\/a><\/strong>.<\/p>\n<ul>\n<li><a href=\"#part1\">Part 1: Protect Excel workbook from opening<\/a><\/li>\n<li><a href=\"#part2\">Part 2: Protect Excel workbook from editing<\/a><\/li>\n<\/ul>\n<h2 id=\"part1\">Part 1: How to protect Excel workbook from opening<\/h2>\n<p>Add a <strong>Document Open Password<\/strong> for an Excel workbook so that all the users should type the correct password to open the workbook.<\/p>\n<p>Step 1: In the opened Excel workbook, click on the <strong>File<\/strong> and select the <strong>Info<\/strong>. Click on the <strong>Protect Workbook<\/strong> button and select the <strong>Encrypt with Password<\/strong> from the expanded options.<\/p>\n<p><a href=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/encrypt-with-password.png\"><img loading=\"lazy\" decoding=\"async\" width=\"495\" height=\"653\" class=\"alignnone wp-image-160 size-full\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/encrypt-with-password.png\" alt=\"Encrypt with Password\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/encrypt-with-password.png 495w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/encrypt-with-password-227x300.png 227w\" sizes=\"auto, (max-width: 495px) 100vw, 495px\" \/><\/a><br \/>\nStep 2: Type your password in the \u201cEncrypt Document\u201d dialog and click <strong>OK<\/strong>. Type the password again in the \u201cConfirm Password\u201d dialog and click <strong>OK<\/strong> to confirm.<\/p>\n<p><a href=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/type-password.png\"><img loading=\"lazy\" decoding=\"async\" width=\"327\" height=\"202\" class=\"alignnone wp-image-161 size-full\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/type-password.png\" alt=\"Type password\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/type-password.png 327w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/type-password-300x185.png 300w\" sizes=\"auto, (max-width: 327px) 100vw, 327px\" \/><\/a><br \/>\nThen the Excel Workbook has been protected from opening. A password will be required to open this workbook.<\/p>\n<h2 id=\"part2\">Part 2: How to protect Excel workbook from editing<\/h2>\n<p>You can mark an Excel workbook as Final or add a password to protect the current sheet from being changed.<\/p>\n<h3>Way 1: Mark as Final<\/h3>\n<p>Step 1: Similarly click on the <strong>Protect Workbook<\/strong> button. Then select <strong>Mark as Final<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/mark-as-final.png\"><img loading=\"lazy\" decoding=\"async\" width=\"448\" height=\"411\" class=\"alignnone wp-image-163 size-full\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/mark-as-final.png\" alt=\"Mark as Final\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/mark-as-final.png 448w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/mark-as-final-300x275.png 300w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/a><br \/>\nStep 2: Click on <strong>OK<\/strong> to confirm.<\/p>\n<p><a href=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/save.png\"><img loading=\"lazy\" decoding=\"async\" width=\"345\" height=\"142\" class=\"alignnone wp-image-166 size-full\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/save.png\" alt=\"Has been marked as final\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/save.png 345w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/save-300x123.png 300w\" sizes=\"auto, (max-width: 345px) 100vw, 345px\" \/><\/a><br \/>\nNow, this Excel workbook has been marked as final to discourage editing. The users will be unable to edit in the cell. But there will be one yellow warning under the Excel toolbar. As long as the user clicks on the <strong>Edit Anyway<\/strong>, he can edit the Excel workbook. But the user had better not do this without the author\u2019s permission if you are not the author.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"655\" height=\"158\" class=\"alignnone wp-image-167 size-full\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/edit-anyway.png\" alt=\"Edit Anyway\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/edit-anyway.png 655w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/edit-anyway-300x72.png 300w\" sizes=\"auto, (max-width: 655px) 100vw, 655px\" \/><\/p>\n<h3>Way 2: Protect the current sheet<\/h3>\n<p>Step 1: Click on the <strong>Protect Workbook<\/strong> button and select <strong>Protect Current Sheet<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/protect-current-sheet.png\"><img loading=\"lazy\" decoding=\"async\" width=\"302\" height=\"406\" class=\"alignnone wp-image-168 size-full\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/protect-current-sheet.png\" alt=\"Protect Current Sheet\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/protect-current-sheet.png 302w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/protect-current-sheet-223x300.png 223w\" sizes=\"auto, (max-width: 302px) 100vw, 302px\" \/><\/a><br \/>\nStep 2: In the <strong>Protect Sheet<\/strong> dialog, type the password to protect the worksheet. Under the <strong>Allow all users of this worksheet to<\/strong>, you can select the options to decide what types of changes the users can make to the worksheet.<\/p>\n<p><a href=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/protect-sheet.png\"><img loading=\"lazy\" decoding=\"async\" width=\"267\" height=\"309\" class=\"alignnone wp-image-169 size-full\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/protect-sheet.png\" alt=\"Type password to protect sheet\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/protect-sheet.png 267w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/protect-sheet-259x300.png 259w\" sizes=\"auto, (max-width: 267px) 100vw, 267px\" \/><\/a><br \/>\nStep 3: Type the password again to confirm.<\/p>\n<p><a href=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/confirrm-password.png\"><img loading=\"lazy\" decoding=\"async\" width=\"325\" height=\"202\" class=\"alignnone wp-image-170 size-full\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/confirrm-password.png\" alt=\"Confirm Password\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/confirrm-password.png 325w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/confirrm-password-300x186.png 300w\" sizes=\"auto, (max-width: 325px) 100vw, 325px\" \/><\/a><br \/>\nNow, the Excel workbook has been protected from editing. Once you attempt to modify the cell, it will prompt the warning message to tell the cell is protected and read-only. Only removing the password from the protected Excel workbook, can you modify the cell.<\/p>\n<p><a href=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/read-only.bmp\"><img loading=\"lazy\" decoding=\"async\" width=\"884\" height=\"124\" class=\"alignnone wp-image-171 size-full\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/read-only.bmp\" alt=\"Protected and Read-only\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/read-only.bmp 884w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/read-only-300x42.bmp 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/read-only-668x94.bmp 668w\" sizes=\"auto, (max-width: 884px) 100vw, 884px\" \/><\/a><\/p>\n<h2>Another way to protect Excel workbook from opening and editing<\/h2>\n<p>Step 1: In an opened Excel workbook, click on <strong>File -&gt; Save As<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/save-as.png\"><img loading=\"lazy\" decoding=\"async\" width=\"167\" height=\"169\" class=\"alignnone wp-image-172 size-full\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/save-as.png\" alt=\"Save as\"><\/a><br \/>\nStep 2: In the <strong>Save As<\/strong> dialog, click on the <strong>Tools<\/strong> button and select <strong>General Options<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"618\" height=\"323\" class=\"alignnone wp-image-299 size-full\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/general-options1.png\" alt=\"General Options\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/general-options1.png 618w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/general-options1-300x157.png 300w\" sizes=\"auto, (max-width: 618px) 100vw, 618px\" \/><br \/>\nStep 3: In the &#8220;General Options&#8221; dialog, you can set an <strong>Open<\/strong> password that protects the Excel workbook from opening and set a <strong>Modify<\/strong> password that protects the Excel workbook from editing.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"279\" height=\"179\" class=\"alignnone wp-image-174 size-full\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/set-password.png\" alt=\"Set Open password and Modify password\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In a study or at work, Microsoft Excel is the most commonly used data handling software. It\u2019s necessary to set a password to protect an Excel workbook that stores important and confidential data. Now from this article, you&#8230; <\/p>\n","protected":false},"author":2,"featured_media":7118,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[],"class_list":["post-159","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Protect Excel Workbook from Opening and Editing<\/title>\n<meta name=\"description\" content=\"This post shows you how to protect an Excel workbook from opening and editing by assigning a password, so unauthorized users can&#039;t open or edit it without the password.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.isumsoft.com\/it\/how-to-protect-excel-workbook-from-opening-and-editing\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Protect Excel Workbook from Opening and Editing\" \/>\n<meta property=\"og:description\" content=\"This post shows you how to protect an Excel workbook from opening and editing by assigning a password, so unauthorized users can&#039;t open or edit it without the password.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.isumsoft.com\/it\/how-to-protect-excel-workbook-from-opening-and-editing\/\" \/>\n<meta property=\"og:site_name\" content=\"iSumsoft\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/isumsofthome\/\" \/>\n<meta property=\"article:published_time\" content=\"2015-06-29T08:12:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-27T09:22:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/protect-excel-workbook-from-open.png\" \/>\n\t<meta property=\"og:image:width\" content=\"650\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Darren\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@iSumsoft\" \/>\n<meta name=\"twitter:site\" content=\"@iSumsoft\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Darren\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-protect-excel-workbook-from-opening-and-editing\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-protect-excel-workbook-from-opening-and-editing\\\/\"},\"author\":{\"name\":\"Darren\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/person\\\/53553bf339aeb82b9c6a240f3b262798\"},\"headline\":\"How to Protect Excel Workbook from Opening and Editing\",\"datePublished\":\"2015-06-29T08:12:41+00:00\",\"dateModified\":\"2019-11-27T09:22:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-protect-excel-workbook-from-opening-and-editing\\\/\"},\"wordCount\":472,\"publisher\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-protect-excel-workbook-from-opening-and-editing\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2015\\\/06\\\/protect-excel-workbook-from-open.png\",\"articleSection\":[\"Office\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-protect-excel-workbook-from-opening-and-editing\\\/\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-protect-excel-workbook-from-opening-and-editing\\\/\",\"name\":\"How to Protect Excel Workbook from Opening and Editing\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-protect-excel-workbook-from-opening-and-editing\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-protect-excel-workbook-from-opening-and-editing\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2015\\\/06\\\/protect-excel-workbook-from-open.png\",\"datePublished\":\"2015-06-29T08:12:41+00:00\",\"dateModified\":\"2019-11-27T09:22:38+00:00\",\"description\":\"This post shows you how to protect an Excel workbook from opening and editing by assigning a password, so unauthorized users can't open or edit it without the password.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-protect-excel-workbook-from-opening-and-editing\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-protect-excel-workbook-from-opening-and-editing\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-protect-excel-workbook-from-opening-and-editing\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2015\\\/06\\\/protect-excel-workbook-from-open.png\",\"contentUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2015\\\/06\\\/protect-excel-workbook-from-open.png\",\"width\":650,\"height\":300,\"caption\":\"protect excel workbook from opening\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-protect-excel-workbook-from-opening-and-editing\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Protect Excel Workbook from Opening and Editing\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#website\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/\",\"name\":\"iSumsoft\",\"description\":\"Tell You More about IT World\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#organization\",\"name\":\"iSumsoft Studio\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/favicon.ico\",\"contentUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/favicon.ico\",\"width\":16,\"height\":16,\"caption\":\"iSumsoft Studio\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/isumsofthome\\\/\",\"https:\\\/\\\/x.com\\\/iSumsoft\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCL9RaYqRcQ0f0buIzXiaNDw\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/person\\\/53553bf339aeb82b9c6a240f3b262798\",\"name\":\"Darren\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/wphb-cache\\\/gravatar\\\/e5e\\\/e5eca2e7a3c501250b3030d7070548bbx96.jpg\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/wphb-cache\\\/gravatar\\\/e5e\\\/e5eca2e7a3c501250b3030d7070548bbx96.jpg\",\"contentUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/wphb-cache\\\/gravatar\\\/e5e\\\/e5eca2e7a3c501250b3030d7070548bbx96.jpg\",\"caption\":\"Darren\"},\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/author\\\/darren-king\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Protect Excel Workbook from Opening and Editing","description":"This post shows you how to protect an Excel workbook from opening and editing by assigning a password, so unauthorized users can't open or edit it without the password.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.isumsoft.com\/it\/how-to-protect-excel-workbook-from-opening-and-editing\/","og_locale":"en_US","og_type":"article","og_title":"How to Protect Excel Workbook from Opening and Editing","og_description":"This post shows you how to protect an Excel workbook from opening and editing by assigning a password, so unauthorized users can't open or edit it without the password.","og_url":"https:\/\/www.isumsoft.com\/it\/how-to-protect-excel-workbook-from-opening-and-editing\/","og_site_name":"iSumsoft","article_publisher":"https:\/\/www.facebook.com\/isumsofthome\/","article_published_time":"2015-06-29T08:12:41+00:00","article_modified_time":"2019-11-27T09:22:38+00:00","og_image":[{"width":650,"height":300,"url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/protect-excel-workbook-from-open.png","type":"image\/png"}],"author":"Darren","twitter_card":"summary_large_image","twitter_creator":"@iSumsoft","twitter_site":"@iSumsoft","twitter_misc":{"Written by":"Darren","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.isumsoft.com\/it\/how-to-protect-excel-workbook-from-opening-and-editing\/#article","isPartOf":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-protect-excel-workbook-from-opening-and-editing\/"},"author":{"name":"Darren","@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/person\/53553bf339aeb82b9c6a240f3b262798"},"headline":"How to Protect Excel Workbook from Opening and Editing","datePublished":"2015-06-29T08:12:41+00:00","dateModified":"2019-11-27T09:22:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-protect-excel-workbook-from-opening-and-editing\/"},"wordCount":472,"publisher":{"@id":"https:\/\/www.isumsoft.com\/it\/#organization"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-protect-excel-workbook-from-opening-and-editing\/#primaryimage"},"thumbnailUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/protect-excel-workbook-from-open.png","articleSection":["Office"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.isumsoft.com\/it\/how-to-protect-excel-workbook-from-opening-and-editing\/","url":"https:\/\/www.isumsoft.com\/it\/how-to-protect-excel-workbook-from-opening-and-editing\/","name":"How to Protect Excel Workbook from Opening and Editing","isPartOf":{"@id":"https:\/\/www.isumsoft.com\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-protect-excel-workbook-from-opening-and-editing\/#primaryimage"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-protect-excel-workbook-from-opening-and-editing\/#primaryimage"},"thumbnailUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/protect-excel-workbook-from-open.png","datePublished":"2015-06-29T08:12:41+00:00","dateModified":"2019-11-27T09:22:38+00:00","description":"This post shows you how to protect an Excel workbook from opening and editing by assigning a password, so unauthorized users can't open or edit it without the password.","breadcrumb":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-protect-excel-workbook-from-opening-and-editing\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.isumsoft.com\/it\/how-to-protect-excel-workbook-from-opening-and-editing\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.isumsoft.com\/it\/how-to-protect-excel-workbook-from-opening-and-editing\/#primaryimage","url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/protect-excel-workbook-from-open.png","contentUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2015\/06\/protect-excel-workbook-from-open.png","width":650,"height":300,"caption":"protect excel workbook from opening"},{"@type":"BreadcrumbList","@id":"https:\/\/www.isumsoft.com\/it\/how-to-protect-excel-workbook-from-opening-and-editing\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.isumsoft.com\/it\/"},{"@type":"ListItem","position":2,"name":"How to Protect Excel Workbook from Opening and Editing"}]},{"@type":"WebSite","@id":"https:\/\/www.isumsoft.com\/it\/#website","url":"https:\/\/www.isumsoft.com\/it\/","name":"iSumsoft","description":"Tell You More about IT World","publisher":{"@id":"https:\/\/www.isumsoft.com\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.isumsoft.com\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.isumsoft.com\/it\/#organization","name":"iSumsoft Studio","url":"https:\/\/www.isumsoft.com\/it\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/logo\/image\/","url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2019\/11\/favicon.ico","contentUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2019\/11\/favicon.ico","width":16,"height":16,"caption":"iSumsoft Studio"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/isumsofthome\/","https:\/\/x.com\/iSumsoft","https:\/\/www.youtube.com\/channel\/UCL9RaYqRcQ0f0buIzXiaNDw"]},{"@type":"Person","@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/person\/53553bf339aeb82b9c6a240f3b262798","name":"Darren","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.isumsoft.com\/it\/wp-content\/wphb-cache\/gravatar\/e5e\/e5eca2e7a3c501250b3030d7070548bbx96.jpg","url":"https:\/\/www.isumsoft.com\/it\/wp-content\/wphb-cache\/gravatar\/e5e\/e5eca2e7a3c501250b3030d7070548bbx96.jpg","contentUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/wphb-cache\/gravatar\/e5e\/e5eca2e7a3c501250b3030d7070548bbx96.jpg","caption":"Darren"},"url":"https:\/\/www.isumsoft.com\/it\/author\/darren-king\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/posts\/159","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/comments?post=159"}],"version-history":[{"count":0,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/posts\/159\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/media\/7118"}],"wp:attachment":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/media?parent=159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/categories?post=159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/tags?post=159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}