{"id":1109,"date":"2016-03-13T07:07:45","date_gmt":"2016-03-13T07:07:45","guid":{"rendered":"http:\/\/www.isumsoft.com\/it\/?p=1109"},"modified":"2019-11-27T03:01:57","modified_gmt":"2019-11-27T03:01:57","slug":"disable-read-only-in-excel-2016","status":"publish","type":"post","link":"https:\/\/www.isumsoft.com\/it\/disable-read-only-in-excel-2016\/","title":{"rendered":"How to Disable Read Only in Excel 2016"},"content":{"rendered":"

If an author has made an Excel 2016 spreadsheet read-only<\/a> to protect it from being modified by others but now you want to remove the read-only mode, read this page to learn how to disable read-only in Excel 2016<\/a><\/strong> based on the three cases.<\/p>\n

Case 1:<\/h2>\n

If the Excel 2016 workbook is just marked as final to let readers to know it is final and read-only, to disable the read-only mode, just need to open the Excel 2016 workbook and then click the Edit Anyway <\/strong>button on the yellow warning appeared at the top of the workbook.<\/p>\n

\"click<\/p>\n

Case 2:<\/h2>\n

If a password to modify is added to protect the Excel 2016 workbook<\/a>, anyone who doesn’t know the true password only can open this workbook in read-only mode and changes he makes can’t be saved unless he saves the workbook with a new name or in a different location. In this case, to disable read-only, do as follows.<\/p>\n

Step 1: Open the Excel 2016 workbook. Type the password for write access and click OK<\/strong>.<\/p>\n

Step 2: Click File -> Save As<\/strong>, select one location where you will save this document.<\/p>\n

Step 3: In the Save As <\/strong>dialog, click the drop-down arrow next to the Tools<\/strong> button, and then select General Options<\/strong>.<\/p>\n

\"Click<\/p>\n

Step 4: In the General Options<\/strong> dialog, delete the password to modify and uncheck the box next to Read-only recommended<\/strong>, and then click OK<\/strong>.<\/p>\n

\"Delete<\/p>\n

Step 5: When you are back to the Save As<\/strong> dialog, click Save<\/strong> to save the workbook. Then the read-only mode in the Excel 2016 workbook can be disabled.<\/p>\n

Case 3:<\/h2>\n

The author of an Excel 2016 workbook may protect the sheet and lock the cells so that users only can open and read the workbook but can’t be able to make changes to it. Once the reader attempts to change the worksheet, he will be prompted with the warning message shown below.<\/p>\n

\"Warning<\/p>\n

In this case, to disable read-only, you need to unprotect the sheet by the following steps.<\/p>\n

Step 1: Open the Excel 2016 workbook.<\/p>\n

Step 2: Select the Review<\/strong> tab and click Unprotect Sheet<\/strong>.<\/p>\n

\"Click<\/p>\n

Step 3: If asked for the password, type it and click OK<\/strong>.<\/p>\n

Tips: If the password has been forgotten or lost, then you need to use VBA codes or 7-zip to unprotect the Excel sheet<\/a> 2016 and disable the read-only.<\/p>\n","protected":false},"excerpt":{"rendered":"

If an author has made an Excel 2016 spreadsheet read-only to protect it from being modified by others but now you want to remove the read-only mode, read this page to learn how to disable read-only in Excel… <\/p>\n","protected":false},"author":2,"featured_media":5769,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[],"class_list":["post-1109","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office"],"yoast_head":"\nHow to Disable Read Only in Excel 2016<\/title>\n<meta name=\"description\" content=\"Excel workbook was set to read-only mode, and you can't make changes to it? Now, this post will show you how to remove or disable Read Only in Excel 2016.\" \/>\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\/disable-read-only-in-excel-2016\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Disable Read Only in Excel 2016\" \/>\n<meta property=\"og:description\" content=\"Excel workbook was set to read-only mode, and you can't make changes to it? Now, this post will show you how to remove or disable Read Only in Excel 2016.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.isumsoft.com\/it\/disable-read-only-in-excel-2016\/\" \/>\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=\"2016-03-13T07:07:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-27T03:01:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2016\/03\/disable-read-only.png\" \/>\n\t<meta property=\"og:image:width\" content=\"585\" \/>\n\t<meta property=\"og:image:height\" content=\"249\" \/>\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\\\/disable-read-only-in-excel-2016\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/disable-read-only-in-excel-2016\\\/\"},\"author\":{\"name\":\"Darren\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/person\\\/53553bf339aeb82b9c6a240f3b262798\"},\"headline\":\"How to Disable Read Only in Excel 2016\",\"datePublished\":\"2016-03-13T07:07:45+00:00\",\"dateModified\":\"2019-11-27T03:01:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/disable-read-only-in-excel-2016\\\/\"},\"wordCount\":380,\"publisher\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/disable-read-only-in-excel-2016\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2016\\\/03\\\/disable-read-only.png\",\"articleSection\":[\"Office\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/disable-read-only-in-excel-2016\\\/\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/disable-read-only-in-excel-2016\\\/\",\"name\":\"How to Disable Read Only in Excel 2016\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/disable-read-only-in-excel-2016\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/disable-read-only-in-excel-2016\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2016\\\/03\\\/disable-read-only.png\",\"datePublished\":\"2016-03-13T07:07:45+00:00\",\"dateModified\":\"2019-11-27T03:01:57+00:00\",\"description\":\"Excel workbook was set to read-only mode, and you can't make changes to it? Now, this post will show you how to remove or disable Read Only in Excel 2016.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/disable-read-only-in-excel-2016\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/disable-read-only-in-excel-2016\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/disable-read-only-in-excel-2016\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2016\\\/03\\\/disable-read-only.png\",\"contentUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2016\\\/03\\\/disable-read-only.png\",\"width\":585,\"height\":249,\"caption\":\"disable read-only in excel 2016\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/disable-read-only-in-excel-2016\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Disable Read Only in Excel 2016\"}]},{\"@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 Disable Read Only in Excel 2016","description":"Excel workbook was set to read-only mode, and you can't make changes to it? Now, this post will show you how to remove or disable Read Only in Excel 2016.","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\/disable-read-only-in-excel-2016\/","og_locale":"en_US","og_type":"article","og_title":"How to Disable Read Only in Excel 2016","og_description":"Excel workbook was set to read-only mode, and you can't make changes to it? Now, this post will show you how to remove or disable Read Only in Excel 2016.","og_url":"https:\/\/www.isumsoft.com\/it\/disable-read-only-in-excel-2016\/","og_site_name":"iSumsoft","article_publisher":"https:\/\/www.facebook.com\/isumsofthome\/","article_published_time":"2016-03-13T07:07:45+00:00","article_modified_time":"2019-11-27T03:01:57+00:00","og_image":[{"width":585,"height":249,"url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2016\/03\/disable-read-only.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\/disable-read-only-in-excel-2016\/#article","isPartOf":{"@id":"https:\/\/www.isumsoft.com\/it\/disable-read-only-in-excel-2016\/"},"author":{"name":"Darren","@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/person\/53553bf339aeb82b9c6a240f3b262798"},"headline":"How to Disable Read Only in Excel 2016","datePublished":"2016-03-13T07:07:45+00:00","dateModified":"2019-11-27T03:01:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.isumsoft.com\/it\/disable-read-only-in-excel-2016\/"},"wordCount":380,"publisher":{"@id":"https:\/\/www.isumsoft.com\/it\/#organization"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/disable-read-only-in-excel-2016\/#primaryimage"},"thumbnailUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2016\/03\/disable-read-only.png","articleSection":["Office"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.isumsoft.com\/it\/disable-read-only-in-excel-2016\/","url":"https:\/\/www.isumsoft.com\/it\/disable-read-only-in-excel-2016\/","name":"How to Disable Read Only in Excel 2016","isPartOf":{"@id":"https:\/\/www.isumsoft.com\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.isumsoft.com\/it\/disable-read-only-in-excel-2016\/#primaryimage"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/disable-read-only-in-excel-2016\/#primaryimage"},"thumbnailUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2016\/03\/disable-read-only.png","datePublished":"2016-03-13T07:07:45+00:00","dateModified":"2019-11-27T03:01:57+00:00","description":"Excel workbook was set to read-only mode, and you can't make changes to it? Now, this post will show you how to remove or disable Read Only in Excel 2016.","breadcrumb":{"@id":"https:\/\/www.isumsoft.com\/it\/disable-read-only-in-excel-2016\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.isumsoft.com\/it\/disable-read-only-in-excel-2016\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.isumsoft.com\/it\/disable-read-only-in-excel-2016\/#primaryimage","url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2016\/03\/disable-read-only.png","contentUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2016\/03\/disable-read-only.png","width":585,"height":249,"caption":"disable read-only in excel 2016"},{"@type":"BreadcrumbList","@id":"https:\/\/www.isumsoft.com\/it\/disable-read-only-in-excel-2016\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.isumsoft.com\/it\/"},{"@type":"ListItem","position":2,"name":"How to Disable Read Only in Excel 2016"}]},{"@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\/1109","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=1109"}],"version-history":[{"count":0,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/posts\/1109\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/media\/5769"}],"wp:attachment":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/media?parent=1109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/categories?post=1109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/tags?post=1109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}