{"id":2011,"date":"2024-12-02T06:45:33","date_gmt":"2024-12-02T06:45:33","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-khac-phuc-loi-khong-mo-duoc-file-xls-tren-excel-2010\/"},"modified":"2024-12-02T06:45:33","modified_gmt":"2024-12-02T06:45:33","slug":"huong-dan-cach-khac-phuc-loi-khong-mo-duoc-file-xls-tren-excel-2010","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-khac-phuc-loi-khong-mo-duoc-file-xls-tren-excel-2010\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c file .xls tr\u00ean Excel 2010"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"h\u1ecdc-excel-online\" cite=\"https:\/\/blog.hocexcel.online\/?hoc-excel-online\">\n<p>Khi s\u1eed d\u1ee5ng phi\u00ean b\u1ea3n Microsoft Excel 2010, 2013, 2016 c\u00f3 th\u1ec3 b\u1ea1n s\u1ebd g\u1eb7p ph\u1ea3i t\u00ecnh hu\u1ed1ng kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c file .xls (file excel phi\u00ean b\u1ea3n 97-2003). Trong b\u00e0i vi\u1ebft n\u00e0y <strong><a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd h\u01b0\u1edbng d\u1eabn <strong>c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c file excel 2010, 2013, 2016<\/strong> r\u1ea5t \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n.<\/p>\n<\/blockquote>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674d578c54e0a\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-khac-phuc-loi-khong-mo-duoc-file-xls-tren-excel-2010.html#Loi_khi_mo_file_xls\" title=\"L\u1ed7i khi m\u1edf file .xls\">L\u1ed7i khi m\u1edf file .xls<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-khac-phuc-loi-khong-mo-duoc-file-xls-tren-excel-2010.html#Cach_1_Thay_doi_thiet_lap_trong_Protect_View\" title=\"C\u00e1ch 1: Thay \u0111\u1ed5i thi\u1ebft l\u1eadp trong Protect View\">C\u00e1ch 1: Thay \u0111\u1ed5i thi\u1ebft l\u1eadp trong Protect View<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-khac-phuc-loi-khong-mo-duoc-file-xls-tren-excel-2010.html#Cach_2_Sua_lai_chuong_trinh_Excel\" title=\"C\u00e1ch 2: S\u1eeda l\u1ea1i ch\u01b0\u01a1ng tr\u00ecnh\u00a0Excel\">C\u00e1ch 2: S\u1eeda l\u1ea1i ch\u01b0\u01a1ng tr\u00ecnh\u00a0Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Loi_khi_mo_file_xls\"><\/span>L\u1ed7i khi m\u1edf file .xls<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Khi m\u1edf file .xls tr\u00ean phi\u00ean b\u1ea3n\u00a0Excel 2010, l\u1ed7i c\u00f3 th\u1ec3 g\u1eb7p ph\u1ea3i l\u00e0 \u201c<strong>The file\u00a0is corrupt and cannot be opened<\/strong>\u201c<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27129\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/the-file-is-corrupt-and-cannot-be-opened.jpg\" width=\"434\" height=\"192\" title=\"the-file-is-corrupt-and-cannot-be-opened\"><\/p>\n<p>L\u1ed7i n\u00e0y c\u00f3 ngh\u0129a l\u00e0 \u201c<strong>File n\u00e0y\u00a0\u0111\u00e3 b\u1ecb h\u1ecfng v\u00e0 kh\u00f4ng th\u1ec3 m\u1edf<\/strong>\u201c. Tuy nhi\u00ean ch\u00fang ta v\u1eabn c\u00f3 th\u1ec3 m\u1edf\u00a0\u0111\u01b0\u1ee3c file khi th\u1ef1c hi\u1ec7n m\u1ed9t trong 2 c\u00e1ch d\u01b0\u1edbi\u00a0\u0111\u00e2y:<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_1_Thay_doi_thiet_lap_trong_Protect_View\"><\/span>C\u00e1ch 1: Thay \u0111\u1ed5i thi\u1ebft l\u1eadp trong Protect View<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 s\u1eeda l\u1ed7i<strong> kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c file excel<\/strong> tr\u01b0\u1edbc ti\u00ean b\u1ea1n s\u1ebd m\u1edf Excel 2010 l\u00ean tr\u01b0\u1edbc (m\u1edf 1 workbook m\u1edbi).<\/p>\n<p>Ti\u1ebfp theo v\u00e0o th\u1ebb File ch\u1ecdn <strong>Options<\/strong><\/p>\n<p>Trong c\u1eeda s\u1ed5\u00a0Excel Options, b\u1ea1n ch\u1ecdn <strong>Trust center Settings<\/strong><\/p>\n<p>Trong m\u1ee5c Trust center, b\u1ea1n t\u00ecm t\u1edbi <strong>Protect view<\/strong>. Trong m\u1ee5c n\u00e0y b\u1ea1n h\u00e3y b\u1ecf h\u1ebft d\u1ea5u t\u00edch ch\u1ecdn trong c\u1ea3 3 m\u1ee5c nh\u01b0 h\u00ecnh d\u01b0\u1edbi\u00a0\u0111\u00e2y:<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-150.gif\" title=\"ex101_92019-nho-150\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-27130\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/trust-center-protect-view-setting-1024x453-1.png\" width=\"800\" height=\"354\" title=\"trust-center-protect-view-setting-1024x453-1\"><\/p>\n<p><strong>* M\u1ee5c\u00a0\u0111\u00edch<\/strong><\/p>\n<p>M\u1ee5c\u00a0\u0111\u00edch c\u1ee7a vi\u1ec7c n\u00e0y l\u00e0 kh\u00f4ng thi\u1ebft l\u1eadp ch\u1ebf\u00a0\u0111\u1ed9 b\u1ea3o v\u1ec7 t\u1ef1\u00a0\u0111\u1ed9ng tr\u01b0\u1edbc c\u00e1c file\u00a0excel kh\u00f4ng r\u00f5 ngu\u1ed3n g\u1ed1c. B\u1edfi vi\u1ec7c b\u1ea3o v\u1ec7 t\u1ef1\u00a0\u0111\u1ed9ng\u00a0\u0111\u00f4i khi s\u1ebd khi\u1ebfn file\u00a0\u0111\u00f3 kh\u00f4ng th\u1ec3 m\u1edf\u00a0\u0111\u01b0\u1ee3c n\u1eefa (do xung\u00a0\u0111\u1ed9t khi\u00a0\u00e1p d\u1ee5ng c\u01a1 ch\u1ebf b\u1ea3o v\u1ec7).<\/p>\n<p>\u0110\u1ed1i t\u01b0\u1ee3ng b\u1ea3o v\u1ec7: C\u00e1c l\u1ec7nh macro ho\u1ea1t\u00a0\u0111\u1ed9ng t\u1ef1\u00a0\u0111\u1ed9ng, c\u00e1c virus c\u00f3 th\u1ec3 k\u00e8m theo file, c\u00e1c ph\u00e9p t\u00ednh to\u00e1n qu\u00e1 nhi\u1ec1u, ph\u1ee9c t\u1ea1p\u2026 g\u00e2y ch\u1eadm h\u1ec7 th\u1ed1ng.<\/p>\n<p><strong>* Ch\u00fa\u00a0\u00fd<\/strong><\/p>\n<p>Vi\u1ec7c t\u1eaft c\u01a1 ch\u1ebf b\u1ea3o v\u1ec7 t\u1ef1\u00a0\u0111\u1ed9ng n\u00e0y ch\u1ec9\u00a0\u00e1p d\u1ee5ng khi b\u1ea1n bi\u1ebft r\u00f5 file c\u1ea7n m\u1edf kh\u00f4ng c\u00f3 c\u00e1c v\u1ea5n\u00a0\u0111\u1ec1 c\u1ea7n b\u1ea3o v\u1ec7. Sau khi m\u1edf\u00a0\u0111\u01b0\u1ee3c file, b\u1ea1n n\u00ean thi\u1ebft l\u1eadp cho ph\u00e9p s\u1eed d\u1ee5ng c\u01a1 ch\u1ebf b\u1ea3o v\u1ec7 t\u1ef1\u00a0\u0111\u1ed9ng\u00a0\u0111\u1ec3 tr\u00e1nh g\u1eb7p v\u1ea5n\u00a0\u0111\u1ec1 v\u1edbi c\u00e1c file kh\u00e1c.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_2_Sua_lai_chuong_trinh_Excel\"><\/span>C\u00e1ch 2: S\u1eeda l\u1ea1i ch\u01b0\u01a1ng tr\u00ecnh\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1ch th\u1ee9 2 \u0111\u1ec3 s\u1eeda l\u1ed7i kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c file excel b\u1ea1n h\u00e3y s\u1eeda l\u1ea1i ch\u01b0\u01a1ng tr\u00ecnh excel theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p>1. B\u1ea5m v\u00e0o n\u00fat Start tr\u00ean m\u00e1y t\u00ednh (ph\u00edm c\u1eeda s\u1ed5 tr\u00ean b\u00e0n ph\u00edm), sau\u00a0\u0111\u00f3 ch\u1ecdn <strong>Control Pannel<\/strong><\/p>\n<p>2. Trong c\u1eeda s\u1ed5 Control Pannel, b\u1ea1n ch\u1ecdn\u00a0<span class=\"text-base\"><strong>Programs and Features<\/strong> &gt; ch\u1ecdn ti\u1ebfp m\u1ee5c\u00a0<strong>Uninstall a program<\/strong><\/span><\/p>\n<p>3. Ch\u1ecdn Microsoft\u00a0Office (b\u1ea3n 2010)<\/p>\n<p>4. B\u1ea5m ch\u1ecdn Change &gt; Cho ph\u00e9p qu\u00e1 tr\u00ecnh s\u1eeda l\u1ed7i, c\u00e0i\u00a0\u0111\u1eb7t l\u1ea1i cho\u00a0Office<\/p>\n<p>5. Sau khi qu\u00e1 tr\u00ecnh s\u1eeda l\u1ed7i, c\u00e0i\u00a0\u0111\u1eb7t l\u1ea1i ho\u00e0n th\u00e0nh,b\u1ea1n c\u00f3 th\u1ec3 th\u1eed m\u1edf l\u1ea1i file\u00a0excel .xls.<\/p>\n<p><strong>* M\u1ee5c\u00a0\u0111\u00edch<\/strong><\/p>\n<p>M\u1ee5c\u00a0\u0111\u00edch c\u1ee7a vi\u1ec7c n\u00e0y l\u00e0 thi\u1ebft l\u1eadp l\u1ea1i to\u00e0n b\u1ed9 ch\u01b0\u01a1ng tr\u00ecnh Microsoft\u00a0Office\u00a0\u0111\u1ec3 x\u00f3a b\u1ecf c\u00e1c l\u1ed7i, c\u00e1c xung\u00a0\u0111\u1ed9t c\u00f3 th\u1ec3 x\u1ea3y ra m\u1ed9t c\u00e1ch t\u1ef1\u00a0\u0111\u1ed9ng.<\/p>\n<p>Ngo\u00e0i ra b\u1ea1n c\u00f3 th\u1ec3 c\u00e0i\u00a0\u0111\u1eb7t phi\u00ean b\u1ea3n m\u1edbi nh\u1ea5t c\u1ee7a Microsoft\u00a0Office\u00a0\u0111\u1ec3 tr\u00e1nh l\u1ed7i tr\u00ean.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n\u00a0\u00e1p d\u1ee5ng th\u00e0nh c\u00f4ng!<\/p>\n<p>Xem th\u00eam c\u00e1c l\u1ed7i kh\u00e1c c\u1ee7a\u00a0Excel:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-sua-loi-excel-bi-dong-khong-unhide-duoc.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eeda l\u1ed7i excel b\u1ecb \u1ea9n d\u00f2ng kh\u00f4ng unhide \u0111\u01b0\u1ee3c<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tim-hieu-ve-loi-na-trong-excel-va-cach-khac-phuc.html\">T\u00ecm hi\u1ec3u v\u1ec1 l\u1ed7i #N\/A trong Excel v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tim-hieu-ve-loi-ref-trong-excel-va-cach-khac-phuc-loi-ref.html\">T\u00ecm hi\u1ec3u v\u1ec1 l\u1ed7i #REF! trong Excel v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i #REF<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-150.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2012,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2011","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2011","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=2011"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2011\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2012"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2011"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2011"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2011"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}