{"id":4098,"date":"2019-12-22T01:50:18","date_gmt":"2019-12-21T22:50:18","guid":{"rendered":"http:\/\/vahamartti.fi\/blog\/?p=4098"},"modified":"2019-12-22T01:50:18","modified_gmt":"2019-12-21T22:50:18","slug":"excel-taulukon-suojauksen-poistaminen-tapa-2","status":"publish","type":"post","link":"http:\/\/vahamartti.fi\/blog\/?p=4098","title":{"rendered":"Excel taulukon suojauksen poistaminen &#8211; tapa 2"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Olen aiemmin <a rel=\"noreferrer noopener\" aria-label=\"esitt\u00e4nyt  (opens in a new tab)\" href=\"http:\/\/vahamartti.fi\/blog\/?p=3963\" target=\"_blank\">esitt\u00e4nyt<\/a> tavan poistaa Excel taulukon solujen suojauksen Visual Basic koodin avulla. Ajoittain t\u00e4m\u00e4 ei kuitenkaan syyst\u00e4 tai toisesta toimi.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">On olemassa toinenkin tapa, jolla suojauksen saa poistettua. T\u00e4m\u00e4 vaihtoehto ei vaadi koodin ajamista, mutta paria kikkaa ja tekstieditoria.  Mik\u00e4li Excelin avaamien on suojattu salasanalla, ei t\u00e4st\u00e4 kikasta ole hy\u00f6ty\u00e4. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">On vaikea sanoa, kumpi n\u00e4ist\u00e4 vaihtoehdoista on helpompi toteuttaa.  Uusi tapa oikein toteutettuna on varmatoiminen solujen suojauksen poistamiseksi, eik\u00e4 koneella tarvitse suorittaa tuntematonta koodia.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">T\u00e4ss\u00e4 vaiheet:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Tee varmuuskopio!<\/li><li>Uudelleennime\u00e4 tiedostop\u00e4\u00e4te .xlsx => .zip<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/vahamartti.fi\/blog\/wp-content\/uploads\/2019\/12\/excel_ikonit-1.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"160\" height=\"105\" src=\"http:\/\/vahamartti.fi\/blog\/wp-content\/uploads\/2019\/12\/excel_ikonit-1.png\" alt=\"\" class=\"wp-image-4103\"\/><\/a><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\"><li>Avaa zip-tiedosto (esim. <a rel=\"noreferrer noopener\" aria-label=\"7-zip (opens in a new tab)\" href=\"https:\/\/www.7-zip.org\/\" target=\"_blank\">7-zip<\/a>:ll\u00e4)<\/li><li>Avaa hakemisto \/xl\/worksheets\/<\/li><li>Hakemisto sis\u00e4lt\u00e4\u00e4 Excelin v\u00e4lilehdet (sheets)<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/vahamartti.fi\/blog\/wp-content\/uploads\/2019\/12\/excel_zippi-1.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"984\" height=\"375\" src=\"http:\/\/vahamartti.fi\/blog\/wp-content\/uploads\/2019\/12\/excel_zippi-1.png\" alt=\"\" class=\"wp-image-4104\" srcset=\"http:\/\/vahamartti.fi\/blog\/wp-content\/uploads\/2019\/12\/excel_zippi-1.png 984w, http:\/\/vahamartti.fi\/blog\/wp-content\/uploads\/2019\/12\/excel_zippi-1-253x96.png 253w, http:\/\/vahamartti.fi\/blog\/wp-content\/uploads\/2019\/12\/excel_zippi-1-768x293.png 768w\" sizes=\"auto, (max-width: 984px) 100vw, 984px\" \/><\/a><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"6\"><li>Avaa v\u00e4lilehdet, joista haluat poistaa suojauksen (esim. sheet1.xml) <\/li><li>Etsi &lt;sheetProtection algorithmName=&#8221;SHA-512&#8243; hashValue=&#8221;&#8230;&#8230;&#8221; \/> ja poista t\u00e4m\u00e4 <\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/vahamartti.fi\/blog\/wp-content\/uploads\/2019\/12\/excel_salaus.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"278\" src=\"http:\/\/vahamartti.fi\/blog\/wp-content\/uploads\/2019\/12\/excel_salaus-1024x278.png\" alt=\"\" class=\"wp-image-4105\" srcset=\"http:\/\/vahamartti.fi\/blog\/wp-content\/uploads\/2019\/12\/excel_salaus-1024x278.png 1024w, http:\/\/vahamartti.fi\/blog\/wp-content\/uploads\/2019\/12\/excel_salaus-253x69.png 253w, http:\/\/vahamartti.fi\/blog\/wp-content\/uploads\/2019\/12\/excel_salaus-768x208.png 768w, http:\/\/vahamartti.fi\/blog\/wp-content\/uploads\/2019\/12\/excel_salaus.png 1214w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"8\"><li>Tallenna muutokset (siten, ett\u00e4 muutokset p\u00e4ivittyv\u00e4t zip-tiedostoon)<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"984\" height=\"373\" src=\"http:\/\/vahamartti.fi\/blog\/wp-content\/uploads\/2019\/12\/image.png\" alt=\"\" class=\"wp-image-4108\" srcset=\"http:\/\/vahamartti.fi\/blog\/wp-content\/uploads\/2019\/12\/image.png 984w, http:\/\/vahamartti.fi\/blog\/wp-content\/uploads\/2019\/12\/image-253x96.png 253w, http:\/\/vahamartti.fi\/blog\/wp-content\/uploads\/2019\/12\/image-768x291.png 768w\" sizes=\"auto, (max-width: 984px) 100vw, 984px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"9\"><li>Lopuksi muuta tiedostop\u00e4\u00e4te takaisin .zip => .xlsx<\/li><li>Solujen ja kaavojen lukitukset on nyt poistettu<\/li><\/ol>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Olen aiemmin esitt\u00e4nyt tavan poistaa Excel taulukon solujen suojauksen Visual Basic koodin avulla. Ajoittain t\u00e4m\u00e4 ei kuitenkaan syyst\u00e4 tai toisesta toimi. On olemassa toinenkin tapa, jolla suojauksen saa poistettua. T\u00e4m\u00e4 vaihtoehto ei vaadi koodin ajamista, mutta paria kikkaa ja tekstieditoria. Mik\u00e4li Excelin avaamien on suojattu salasanalla, ei t\u00e4st\u00e4 kikasta ole hy\u00f6ty\u00e4. On vaikea sanoa, kumpi &hellip; <a href=\"http:\/\/vahamartti.fi\/blog\/?p=4098\" class=\"more-link\">Jatka lukemista <span class=\"screen-reader-text\">Excel taulukon suojauksen poistaminen &#8211; tapa 2<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[30,384],"tags":[981,985,984,1013,986,1012,982],"class_list":["post-4098","post","type-post","status-publish","format-standard","hentry","category-saatoa","category-vinkit","tag-excel","tag-lukittu","tag-salasana","tag-solu","tag-suojattu","tag-suojaus","tag-taulukko"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1fteB-146","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"http:\/\/vahamartti.fi\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4098","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/vahamartti.fi\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/vahamartti.fi\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/vahamartti.fi\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/vahamartti.fi\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4098"}],"version-history":[{"count":7,"href":"http:\/\/vahamartti.fi\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4098\/revisions"}],"predecessor-version":[{"id":4111,"href":"http:\/\/vahamartti.fi\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4098\/revisions\/4111"}],"wp:attachment":[{"href":"http:\/\/vahamartti.fi\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4098"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/vahamartti.fi\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4098"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/vahamartti.fi\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4098"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}