{"id":3686,"date":"2024-12-03T03:28:20","date_gmt":"2024-12-03T03:28:20","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-khac-phuc-loi-excel-found-unreadable-content\/"},"modified":"2024-12-03T03:28:20","modified_gmt":"2024-12-03T03:28:20","slug":"huong-dan-cach-khac-phuc-loi-excel-found-unreadable-content","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-cach-khac-phuc-loi-excel-found-unreadable-content\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i excel found unreadable content"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>M\u1ed9t ng\u00e0y\u00a0\u0111\u1eb9p tr\u1eddi b\u1ea1n m\u1edf 1 file\u00a0Excel l\u00ean v\u00e0 b\u1ed7ng nh\u1eadn\u00a0\u0111\u01b0\u1ee3c d\u00f2ng th\u00f4ng b\u00e1o nh\u01b0 sau:<\/p>\n<p>\u201cExcel found\u00a0unreadable content\u2026.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17488\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-unreadable-content-fix-01.png\" width=\"1014\" height=\"154\" title=\"heo-unreadable-content-fix-01\"><\/p>\n<p>D\u00f2ng th\u00f4ng b\u00e1o l\u1ed7i n\u00e0y c\u00f3 ngh\u0129a l\u00e0 g\u00ec, t\u1ea1i sao l\u1ea1i c\u00f3 th\u00f4ng b\u00e1o\u00a0\u0111\u00f3, c\u00e1ch kh\u1eafc ph\u1ee5c\u00a0l\u1ed7i n\u00e0y nh\u01b0 th\u1ebf n\u00e0o, h\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u nh\u00e9.<\/p>\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-674e7ad352507\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-khac-phuc-loi-excel-found-unreadable-content.html#1_Y_nghia_cua_thong_bao_loi_Excel_found_unreadable_content\" title=\"1.\u00a0\u00dd ngh\u0129a c\u1ee7a th\u00f4ng b\u00e1o l\u1ed7i\u00a0Excel found\u00a0unreadable content\">1.\u00a0\u00dd ngh\u0129a c\u1ee7a th\u00f4ng b\u00e1o l\u1ed7i\u00a0Excel found\u00a0unreadable content<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-khac-phuc-loi-excel-found-unreadable-content.html#2_Nguyen_nhan_loi_Excel_found_unreadable_content\" title=\"2. Nguy\u00ean nh\u00e2n\u00a0l\u1ed7i\u00a0Excel found\u00a0unreadable content\">2. Nguy\u00ean nh\u00e2n\u00a0l\u1ed7i\u00a0Excel found\u00a0unreadable content<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-khac-phuc-loi-excel-found-unreadable-content.html#3_Cach_khac_phuc_loi_Excel_found_unreadable_content\" title=\"3. C\u00e1ch kh\u1eafc ph\u1ee5c\u00a0l\u1ed7i\u00a0Excel found\u00a0unreadable content\">3. C\u00e1ch kh\u1eafc ph\u1ee5c\u00a0l\u1ed7i\u00a0Excel found\u00a0unreadable content<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_Y_nghia_cua_thong_bao_loi_Excel_found_unreadable_content\"><\/span>1.\u00a0\u00dd ngh\u0129a c\u1ee7a th\u00f4ng b\u00e1o l\u1ed7i\u00a0Excel found\u00a0unreadable content<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u1ebfu b\u1ea1n\u00a0\u0111em c\u1ea3 c\u00e2u th\u00f4ng b\u00e1o\u00a0\u1edf tr\u00ean v\u00e0o google d\u1ecbch th\u00ec s\u1ebd hi\u1ec3u\u00a0\u0111\u01b0\u1ee3c l\u00e0:<\/p>\n<ul>\n<li>Excel (phi\u00ean b\u1ea3n\u00a0excel trong m\u00e1y t\u00ednh b\u1ea1n\u00a0\u0111ang s\u1eed d\u1ee5ng) ph\u00e1t hi\u1ec7n ra 1 n\u1ed9i dung m\u00e0 n\u00f3 kh\u00f4ng\u00a0\u0111\u1ecdc\u00a0\u0111\u01b0\u1ee3c trong\u00a0workbook b\u1ea1n\u00a0\u0111ang m\u1edf (l\u00e0 ph\u1ea7n\u00a0\u1edf \u2018TH.xls\u2019 trong\u00a0\u0111\u00f3 TH l\u00e0 t\u00ean\u00a0workbook, xls l\u00e0\u00a0\u0111u\u00f4i file, d\u1ea1ng file\u00a0\u0111\u00f3)<\/li>\n<li>B\u1ea1n c\u00f3 mu\u1ed1n ph\u1ee5c h\u1ed3i ph\u1ea7n n\u1ed9i dung kh\u00f4ng\u00a0\u0111\u1ecdc\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u00f3 kh\u00f4ng? N\u1ebfu b\u1ea1n tin t\u01b0\u1edfng v\u00e0o ngu\u1ed3n c\u1ee7a\u00a0workbook n\u00e0y th\u00ec b\u1ea5m\u00a0Yes.<\/li>\n<\/ul>\n<p>T\u1ee9c l\u00e0:<\/p>\n<p>File m\u00e0 b\u1ea1n\u00a0\u0111ang m\u1edf c\u00f3 ch\u1ee9a n\u1ed9i dung m\u00e0 phi\u00ean b\u1ea3n\u00a0Excel kh\u00f4ng\u00a0\u0111\u1ecdc\u00a0\u0111\u01b0\u1ee3c, kh\u00f4ng hi\u1ec3u\u00a0\u0111\u01b0\u1ee3c. Do\u00a0\u0111\u00f3\u00a0Excel g\u1ee3i\u00a0\u00fd b\u1ea1n c\u00f3 mu\u1ed1n\u00a0\u0111\u1ec3\u00a0Excel t\u1ef1 bi\u00ean d\u1ecbch l\u1ea1i\u00a0\u0111o\u1ea1n kh\u00f4ng hi\u1ec3u\u00a0\u0111\u00f3 kh\u00f4ng. N\u1ebfu\u00a0\u0111\u1ed3ng\u00a0\u00fd th\u00ec b\u1ea5m\u00a0Yes, kh\u00f4ng\u00a0\u0111\u1ed3ng\u00a0\u00fd th\u00ec b\u1ea5m No.<\/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-286.gif\" title=\"ex101_92019-nho-286\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>Khi b\u1ea5m\u00a0<strong>Yes<\/strong> th\u00ec s\u1ebd th\u1ef1c hi\u1ec7n qu\u00e1 tr\u00ecnh kh\u00f4i ph\u1ee5c. Tuy nhi\u00ean vi\u1ec7c n\u00e0y <em><strong>c\u00f3 th\u1ec3<\/strong> <\/em>g\u00e2y ra l\u1ed7i v\u00e0 khi\u1ebfn to\u00e0n b\u1ed9 file c\u1ee7a b\u1ea1n b\u1ecb h\u1ecfng. C\u1ea7n c\u00e2n nh\u1eafc k\u1ef9 khi l\u00e0m\u00a0\u0111i\u1ec1u n\u00e0y.<\/li>\n<li>Khi b\u1ea5m <strong>No<\/strong> th\u00ec\u00a0Excel s\u1ebd\u00a0\u0111\u00f3ng file l\u1ea1i, kh\u00f4ng l\u00e0m g\u00ec c\u1ea3.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"2_Nguyen_nhan_loi_Excel_found_unreadable_content\"><\/span>2. Nguy\u00ean nh\u00e2n\u00a0l\u1ed7i\u00a0Excel found\u00a0unreadable content<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Nguy\u00ean nh\u00e2n th\u01b0\u1eddng g\u1eb7p nh\u1ea5t l\u00e0 b\u1ea1n s\u1eed d\u1ee5ng\u00a0Excel\u00a0\u1edf c\u00e1c phi\u00ean b\u1ea3n\u00a0\u0111\u1eddi c\u0169 (\u0111\u1eb7c bi\u1ec7t l\u00e0 b\u1ea3n Microsoft\u00a0Office 2007), trong khi file b\u1ea1n\u00a0\u0111ang mu\u1ed1n m\u1edf l\u1ea1i c\u00f3 ch\u1ee9a c\u00e1c n\u1ed9i dung, c\u00e2u l\u1ec7nh, thao t\u00e1c m\u00e0 ch\u1ec9 c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n\u00a0\u1edf c\u00e1c phi\u00ean b\u1ea3n\u00a0\u0111\u1eddi cao h\u01a1n (2010, 2013, 2016\u2026)<\/p>\n<p>Trong phi\u00ean b\u1ea3n 2007 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n cao h\u01a1n c\u00f3 s\u1ef1 n\u00e2ng c\u1ea5p, thay \u0111\u1ed5i kh\u00e1 nhi\u1ec1u. Vi\u1ec7c n\u00e0y d\u1eabn t\u1edbi c\u00f3 1 v\u00e0i thao t\u00e1c s\u1eed d\u1ee5ng r\u1ea5t quen thu\u1ed9c v\u00e0 b\u00ecnh th\u01b0\u1eddng \u1edf Excel 2010 trong khi l\u1ea1i kh\u00f4ng s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c \u1edf trong Excel 2007, v\u00ed d\u1ee5 nh\u01b0 <strong>Data Validation \/ List<\/strong>: Ngu\u1ed3n n\u1ea1p v\u00e0o List l\u1ea5y t\u1eeb Sheet kh\u00e1c, l\u1ea5y t\u1eeb 1 Name t\u1ea1i sheet kh\u00e1c; hay nh\u01b0 vi\u1ec7c s\u1eed d\u1ee5ng VBA trong\u00a0Excel 2007 c\u0169ng kh\u00e1c nhi\u1ec1u so v\u1edbi\u00a0Excel 2010, 2013, 2016\u2026<\/p>\n<p>Ch\u00ednh v\u00ec v\u1eady khi phi\u00ean b\u1ea3n\u00a0Excel b\u1ea1n\u00a0\u0111ang s\u1eed d\u1ee5ng kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 c\u00e1c t\u00ednh n\u0103ng\u00a0\u0111\u00f3, d\u1eabn t\u1edbi n\u00f3 kh\u00f4ng\u00a0\u0111\u1ecdc\u00a0\u0111\u01b0\u1ee3c n\u1ed9i dung =&gt; G\u1ee3i\u00a0\u00fd b\u1ea1n\u00a0\u0111\u1ec3\u00a0Excel t\u1ef1 ph\u1ee5c h\u1ed3i, t\u1ef1 hi\u1ec3u theo c\u00e1ch hi\u1ec3u c\u1ee7a phi\u00ean b\u1ea3n\u00a0\u0111\u1eddi c\u0169. Vi\u1ec7c n\u00e0y c\u00f3 s\u1ef1 r\u1ee7i ro kh\u00e1c cao khi h\u1ea7u h\u1ebft kh\u00f4ng ph\u1ee5c h\u1ed3i\u00a0\u0111\u01b0\u1ee3c, ho\u1eb7c ph\u1ee5c h\u1ed3i theo 1 h\u01b0\u1edbng sai so v\u1edbi mong mu\u1ed1n c\u1ee7a ch\u00fang ta.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Cach_khac_phuc_loi_Excel_found_unreadable_content\"><\/span>3. C\u00e1ch kh\u1eafc ph\u1ee5c\u00a0l\u1ed7i\u00a0Excel found\u00a0unreadable content<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ch\u00fang ta n\u00ean th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li>B\u1ea5m <strong>No<\/strong> khi nh\u1eadn\u00a0\u0111\u01b0\u1ee3c th\u00f4ng b\u00e1o tr\u00ean<\/li>\n<li>Ki\u1ec3m tra l\u1ea1i phi\u00ean b\u1ea3n\u00a0Excel\u00a0\u0111ang s\u1eed d\u1ee5ng<\/li>\n<li>Th\u1eed m\u1edf file\u00a0\u0111\u00f3 tr\u00ean phi\u00ean b\u1ea3n\u00a0Excel\u00a0\u0111\u1eddi cao h\u01a1n (th\u01b0\u1eddng l\u00e0 t\u1eeb 2010 tr\u1edf\u00a0\u0111i) xem c\u00f3 g\u1eb7p l\u1ea1i l\u1ed7i\u00a0\u0111\u00f3 kh\u00f4ng<\/li>\n<li>N\u1ebfu m\u1edf kh\u00f4ng c\u00f3 l\u1ed7i th\u00ec ki\u1ec3m tra l\u1ea1i c\u00e1c n\u1ed9i dung nh\u01b0 VBA, Data Validation, Name Manager\u2026\u00a0\u0111\u1ec3 xem c\u00f3 n\u1ed9i dung n\u00e0o kh\u00f4ng t\u01b0\u01a1ng th\u00edch v\u1edbi b\u1ea3n 2007 th\u00ec s\u1eeda l\u1ea1i<\/li>\n<li>M\u1edf file s\u1eeda l\u1ea1i trong phi\u00ean b\u1ea3n\u00a0Excel 2007 xem c\u00f3 th\u00f4ng b\u00e1o l\u1ed7i\u00a0\u0111\u00f3 n\u1eefa kh\u00f4ng<\/li>\n<\/ul>\n<p>C\u00e1ch t\u1ed1t nh\u1ea5t l\u00e0 n\u00ean c\u00e0i l\u1ea1i phi\u00ean b\u1ea3n Microsoft\u00a0Office 2010 tr\u1edf l\u00ean.<\/p>\n<p><strong>Ngo\u00e0i ra b\u1ea1n c\u00f3 th\u1ec3 xem h\u01b0\u1edbng d\u1eabn chi ti\u1ebft h\u01a1n v\u1ec1 c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-khac-phuc-loi-khong-mo-duoc-file-xls-tren-excel-2010.html\">excel 2010 kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c file xls<\/a> <\/strong><\/p>\n<p><strong>* L\u01b0u\u00a0\u00fd:<\/strong><\/p>\n<ul>\n<li>N\u1ebfu m\u1edf b\u1eb1ng phi\u00ean b\u1ea3n\u00a0\u0111\u1eddi cao m\u00e0 v\u1eabn g\u1eb7p l\u1ed7i n\u00e0y th\u00ec c\u1ea7n nh\u1edd t\u1edbi ng\u01b0\u1eddi c\u00f3 nhi\u1ec1u kinh nghi\u1ec7m h\u01a1n\u00a0\u0111\u1ec3 gi\u00fap b\u1ea1n x\u1eed l\u00fd, v\u00ec ch\u1eafc ch\u1eafn n\u1ed9i dung kh\u00f4ng x\u00e1c\u00a0\u0111\u1ecbnh n\u00e0y c\u00f3 t\u00ednh ch\u1ea5t ph\u1ee9c t\u1ea1p<\/li>\n<li>Kh\u00f4ng t\u1ef1\u00a0\u00fd b\u1ea5m\u00a0Yes v\u00ec khi file\u00a0\u0111\u00e3 recover th\u00ec kh\u00f4ng th\u1ec3 tr\u1edf v\u1ec1 tr\u1ea1ng th\u00e1i c\u0169\u00a0\u0111\u01b0\u1ee3c n\u1eefa.<\/li>\n<\/ul>\n<p>Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!<\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n \u201c<strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong>\u201c.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0\u0111\u00e1p\u00a0\u1ee9ng y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c t\u1ed5 ch\u1ee9c, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u v\u00e0 l\u1eadp b\u00e1o c\u00e1o tr\u00ean\u00a0Excel.<\/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-286.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3687,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3686","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\/3686","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=3686"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3686\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3687"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3686"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3686"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3686"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}