{"id":45217,"date":"2021-11-28T22:52:11","date_gmt":"2021-11-28T15:52:11","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=45217"},"modified":"2021-12-14T10:15:26","modified_gmt":"2021-12-14T03:15:26","slug":"loi-khong-mo-duoc-file-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/loi-khong-mo-duoc-file-excel\/","title":{"rendered":"S\u1eeda l\u1ed7i kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c File Excel v\u1edbi 6 c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t"},"content":{"rendered":"

L\u1ed7i kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c File Excel<\/strong> di\u1ec5n ra r\u1ea5t ph\u1ed5 bi\u1ebfn v\u00e0 b\u1edfi nhi\u1ec1u nguy\u00ean nh\u00e2n kh\u00e1c nhau. \u0110\u1ec3 c\u00f3 th\u1ec3 x\u1eed l\u00fd nhanh nh\u1ea5t th\u00ec ng\u01b0\u1eddi d\u00f9ng c\u0169ng c\u1ea7n n\u1eafm \u0111\u01b0\u1ee3c r\u00f5 nguy\u00ean nh\u00e2n g\u00e2y n\u00ean t\u00ecnh tr\u1ea1ng n\u00e0y. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Ben Computer s\u1ebd \u0111\u01b0a ra nh\u1eefng nguy\u00ean nh\u00e2n v\u00e0 h\u01b0\u1edbng d\u1eabn s\u1eeda l\u1ed7i\u00a0file excel kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c tr\u1ef1c ti\u1ebfp<\/strong> nhanh, \u0111\u01a1n gi\u1ea3n nh\u1ea5t. H\u00e3y tham kh\u1ea3o b\u00e0i vi\u1ebft v\u00e0 \u00e1p d\u1ee5ng ngay nh\u00e9!<\/p>\n

I. C\u00e1c nguy\u00ean nh\u00e2n g\u00e2y l\u1ed7i kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c File Excel<\/strong><\/h2>\n

\"l\u1ed7i<\/p>\n

C\u00f3 nhi\u1ec1u nguy\u00ean nh\u00e2n g\u00e2y l\u1ed7i kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c file XLSX<\/strong><\/em><\/p>\n

L\u1ed7i kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c Excel “the file is corrupt and cannot be opened” c\u00f3 r\u1ea5t nhi\u1ec1u nguy\u00ean nh\u00e2n kh\u00e1c nhau. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t v\u00e0i nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn nh\u1ea5t g\u00e2y ra l\u1ed7i n\u00e0y:<\/p>\n

– Phi\u00ean b\u1ea3n Excel c\u0169 n\u00ean kh\u00f4ng th\u1ec3 m\u1edf File Excel c\u1ee7a phi\u00ean b\u1ea3n m\u1edbi.<\/p>\n

– T\u1eadp tin khi t\u1ea3i v\u1ec1 \u0111\u00e3 b\u1ecb l\u1ed7i n\u00ean kh\u00f4ng th\u1ec3 m\u1edf.<\/p>\n

– Excel v\u1eabn \u0111ang m\u1edf ch\u1ebf \u0111\u1ed9 t\u00ednh to\u00e1n t\u1ef1 \u0111\u1ed9ng.<\/p>\n

– M\u00e1y t\u00ednh \u0111ang b\u1ecb virus t\u1ea5n c\u00f4ng n\u00ean kh\u00f4ng th\u1ec3 m\u1edf \u0111\u01b0\u1ee3c ph\u1ea7n m\u1ec1m Excel.<\/p>\n

– \u0110\u1ecbnh d\u1ea1ng File sai.<\/p>\n

II. C\u00e1ch x\u1eed l\u00fd khi b\u1ecb l\u1ed7i kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c File Excel<\/strong><\/h2>\n

V\u1edbi t\u1eebng tr\u01b0\u1eddng h\u1ee3p, l\u1ed7i kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c File Excel s\u1ebd \u0111\u01b0\u1ee3c kh\u1eafc ph\u1ee5c theo nhi\u1ec1u c\u00e1ch kh\u00e1c nhau. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 c\u00e1ch kh\u1eafc ph\u1ee5c ph\u1ed5 bi\u1ebfn nh\u1ea5t, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng:<\/p>\n

1. C\u00e0i \u0111\u1eb7t phi\u00ean b\u1ea3n Excel m\u1edbi<\/strong><\/h3>\n

C\u00e1c phi\u00ean b\u1ea3n Excel c\u0169 ch\u1ec9 c\u00f3 th\u1ec3 m\u1edf \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u0111u\u00f4i .xls. C\u00f2n v\u1edbi c\u00e1c \u0111u\u00f4i .xlsx ch\u1ec9 c\u00f3 th\u1ec3 m\u1edf \u1edf phi\u00ean b\u1ea3n Excel m\u1edbi. Ch\u00ednh v\u00ec th\u1ebf, n\u1ebfu file Excel b\u1ea1n nh\u1eadn thu\u1ed9c d\u1ea1ng \u0111u\u00f4i .xlsx th\u00ec ph\u1ea3i t\u1ea3i phi\u00ean b\u1ea3n m\u1edbi nh\u1ea5t v\u1ec1 m\u00e1y. T\u1ed1t nh\u1ea5t, b\u1ea1n v\u1eabn n\u00ean c\u1eadp nh\u1eadt Excel theo \u0111\u00fang c\u00e1c phi\u00ean b\u1ea3n m\u1edbi \u0111\u1ec3 c\u00f3 \u0111\u1ea7y \u0111\u1ee7 c\u00e1c t\u00ednh n\u0103ng v\u00e0 kh\u00f4ng b\u1ecb l\u1ed7i khi m\u1edf File.<\/p>\n

\"l\u1ed7i<\/p>\n

T\u1ea3i phi\u00ean b\u1ea3n Excel m\u1edbi nh\u1ea5t<\/em><\/p>\n

2. \u0110\u1ed5i \u0111u\u00f4i File Excel<\/strong><\/h3>\n

Trong tr\u01b0\u1eddng h\u1ee3p l\u1ed7i kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c File Excel l\u00e0 do \u0111u\u00f4i thu\u1ed9c d\u1ea1ng .xlsx m\u00e0 phi\u00ean b\u1ea3n Excel c\u1ee7a b\u1ea1n thu\u1ed9c phi\u00ean b\u1ea3n c\u0169, ch\u01b0a th\u1ec3 t\u1ea3i \u0111\u01b0\u1ee3c b\u1ea3n m\u1edbi th\u00ec h\u00e3y \u0111\u1ed5i \u0111u\u00f4i File. C\u00e1ch th\u1ef1c hi\u1ec7n vi\u1ec7c \u0111\u1ed5i \u0111u\u00f4i c\u0169ng kh\u00e1 \u0111\u01a1n gi\u1ea3n, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5n n\u00fat F2 \u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c \u0111\u1ed5i t\u00ean. Sau \u0111\u00f3, khi l\u01b0u file h\u00e3y \u0111\u1ed5i l\u1ea1i t\u00ean \u0111u\u00f4i cho ph\u00f9 h\u1ee3p.<\/p>\n

\"l\u1ed7i<\/p>\n

\u0110\u1ed5i \u0111\u1ecbnh d\u1ea1ng \u0111u\u00f4i \u0111\u1ec3 m\u1edf file cho ph\u00f9 h\u1ee3p<\/em><\/p>\n

3. D\u00f9ng t\u00ednh n\u0103ng t\u1ef1 \u0111\u1ed9ng s\u1eeda l\u1ed7i<\/strong><\/h3>\n

Trong tr\u01b0\u1eddng h\u1ee3p nguy\u00ean nh\u00e2n g\u00e2y l\u1ed7i kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c file Excel l\u00e0 do t\u1eadp tin b\u1ecb l\u1ed7i th\u00ec b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng t\u1ef1 \u0111\u1ed9ng s\u1eeda l\u1ed7i. Chi ti\u1ebft nh\u01b0 sau:<\/p>\n

B\u01b0\u1edbc 1:<\/strong> M\u1edf file, ch\u1ecdn Open<\/strong> v\u00e0 ch\u1ecdn Browse.<\/strong><\/p>\n

\"l\u1ed7i<\/p>\n

Ch\u1ecdn Open sau \u0111\u00f3 ch\u1ecdn Browse<\/em><\/p>\n

B\u01b0\u1edbc 2:<\/strong> T\u00ecm File Excel \u0111ang l\u1ed7i v\u00e0 mu\u1ed1n kh\u00f4i ph\u1ee5c, l\u1ef1a ch\u1ecdn Open and Repair.<\/strong><\/p>\n

\"s\u1eeda<\/p>\n

Ch\u1ecdn Open and Repair<\/em><\/p>\n

B\u01b0\u1edbc 3:<\/strong> L\u00fac n\u00e0y s\u1ebd c\u00f3 h\u1ed9p tho\u1ea1i xu\u1ea5t hi\u1ec7n, ch\u1ecdn Repair<\/strong> \u0111\u1ec3 s\u1eeda. N\u1ebfu mu\u1ed1n tr\u00edch xu\u1ea5t ngay d\u1eef li\u1ec7u b\u00ean trong nhanh nh\u1ea5t, h\u00e3y ch\u1ecdn Extract Data.<\/strong><\/p>\n

\"l\u1ed7i<\/p>\n

Ch\u1ecdn Repair \u0111\u1ec3 b\u1eaft \u0111\u1ea7u s\u1eeda<\/em><\/p>\n

4. T\u1eaft ch\u1ebf \u0111\u1ed9 t\u00ednh to\u00e1n t\u1ef1 \u0111\u1ed9ng tr\u00ean Excel<\/strong><\/h3>\n

Ch\u1ebf \u0111\u1ed9 t\u00ednh to\u00e1n t\u1ef1 \u0111\u1ed9ng c\u0169ng l\u00e0 m\u1ed9t nguy\u00ean nh\u00e2n g\u00e2y l\u1ed7i kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c file Excel. Do \u0111\u00f3, b\u1ea1n c\u1ea7n t\u1eaft ch\u1ebf \u0111\u1ed9 n\u00e0y theo nh\u1eefng b\u01b0\u1edbc sau:<\/p>\n

B\u01b0\u1edbc 1:<\/strong> M\u1edf Excel, ch\u1ecdn File<\/strong> v\u00e0 ch\u1ecdn Option<\/strong>.<\/p>\n

B\u01b0\u1edbc 2:<\/strong> Trong ph\u1ea7n Excel Options, ch\u1ecdn Formulas<\/strong>, Workbook Calculation<\/strong> \u0111\u1ec3 chuy\u1ec3n sang ph\u1ea7n Manual,<\/strong> \u1ea5n Ok<\/strong> \u0111\u1ec3 l\u01b0u v\u00f4 hi\u1ec7u h\u00f3a ch\u1ebf \u0111\u1ed9 t\u00ednh to\u00e1n t\u1ef1 \u0111\u1ed9ng.<\/p>\n

\"s\u1eeda<\/p>\n

C\u00e1c thao t\u00e1c th\u1ef1c hi\u1ec7n \u0111\u00ea rbor ch\u1ebf \u0111\u1ed9 t\u00ednh to\u00e1n t\u1ef1 \u0111\u1ed9ng\u00a0<\/em><\/p>\n

B\u01b0\u1edbc 3:<\/strong> \u1ea4n ch\u1ecdn File<\/strong>, Open v\u00e0 Browse<\/strong> \u0111\u1ec3 t\u00ecm \u0111\u1ebfn file b\u1ecb l\u1ed7i, ki\u1ec3m tra xem \u0111\u00e3 m\u1edf \u0111\u01b0\u1ee3c file ch\u01b0a nh\u00e9!<\/p>\n

5. V\u00f4 hi\u1ec7u h\u00f3a Protected View<\/strong><\/h3>\n

Protected View l\u00e0 ch\u1ebf \u0111\u1ed9 xem \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 nh\u01b0ng n\u00f3 c\u0169ng c\u00f3 th\u1ec3 g\u00e2y h\u1ea1i \u0111\u1ebfn m\u00e1y t\u00ednh. V\u00f4 hi\u1ec7u h\u00f3a Procted view s\u1ebd c\u00f3 th\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c file Excel. C\u00e1c b\u01b0\u1edbc chi ti\u1ebft \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n

B\u01b0\u1edbc 1:<\/strong> M\u1edf Excel, ch\u1ecdn File<\/strong> v\u00e0 ch\u1ecdn Options.<\/strong><\/p>\n

B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn Trust Center<\/strong> v\u00e0 ch\u1ecdn ti\u1ebfp Trust Center Setttings<\/strong>.<\/p>\n

\"l\u1ed7i<\/p>\n

Ch\u1ecdn Trust Center v\u00e0 Trust Center Settting<\/em><\/p>\n

B\u01b0\u1edbc 3:<\/strong> Ch\u1ecdn Protected View<\/strong> v\u00e0 b\u1ecf ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 vu\u00f4ng, \u1ea5n ch\u1ecdn Ok.<\/strong><\/p>\n

\"kh\u1eafc<\/p>\n

Protected View sau \u0111\u00f3 b\u1ecf ch\u1ecdn c\u00e1c \u00f4 b\u00ean trong<\/em><\/p>\n

B\u01b0\u1edbc 4:<\/strong> Kh\u1edfi \u0111\u1ed9ng l\u1ea1i Excel. L\u00fac n\u00e0y, b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 m\u1edf file Excel b\u1ecb l\u1ed7i tr\u01b0\u1edbc \u0111\u00f3.<\/p>\n

6. Kh\u00f4i ph\u1ee5c b\u1eb1ng ph\u1ea7n m\u1ec1m<\/strong><\/h3>\n

N\u1ebfu nh\u01b0 th\u1ef1c hi\u1ec7n nh\u1eefng c\u00e1ch tr\u00ean m\u00e0 v\u1eabn g\u1eb7p l\u1ed7i kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c file Excel<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m Easy Office Recovery<\/strong>. T\u1ea3i ph\u1ea7n m\u1ec1m v\u1ec1 m\u00e1y v\u00e0 l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n

B\u01b0\u1edbc 1:<\/strong> M\u1edf ph\u1ea7n m\u1ec1m, ch\u1ecdn File<\/strong> v\u00e0 ch\u1ecdn Open Data file<\/strong>.<\/p>\n

\"kh\u1eafc<\/p>\n

Ch\u1ecdn File v\u00e0 \u1ea5n ch\u1ecdn Open Data file<\/em><\/p>\n

B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn Open File<\/strong> v\u00e0 sau \u0111\u00f3 ch\u1ec9 \u0111\u01b0\u1eddng d\u1eabn t\u1edbi file Excel l\u1ed7i kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c.<\/p>\n

\"kh\u00f4ng<\/p>\n

Ch\u1ecdn Open File v\u00e0 ch\u1ecdn v\u00e0o File \u0111ang b\u1ecb l\u1ed7i<\/em><\/p>\n

B\u01b0\u1edbc 3:<\/strong> L\u00fac n\u00e0y, to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong File \u0111\u00e3 \u0111\u01b0\u1ee3c hi\u1ec7n l\u00ean. B\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn File<\/strong>, ch\u1ecdn Recover data<\/strong> v\u00e0 nh\u1ea5n Browse<\/strong>, ch\u1ecdn th\u01b0 m\u1ee5c l\u01b0u, \u1ea5n Next<\/strong>.<\/p>\n

\"l\u1ed7i<\/p>\n

Nh\u1ea5n ch\u1ecdn Browse, ch\u1ecdn th\u01b0 m\u1ee5c l\u01b0u, ch\u1ecdn Next<\/em><\/p>\n

B\u01b0\u1edbc 4:<\/strong> Khi c\u00f3 hi\u1ec7n th\u00f4ng b\u00e1o Files were successfully recovered<\/strong> l\u00e0 \u0111\u00e3 ho\u00e0n th\u00e0nh.<\/p>\n

Tr\u00ean \u0111\u00e2y, c\u00e1c b\u1ea1n \u0111\u00e3 \u0111\u01b0\u1ee3c t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c l\u1ed7i kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c file Excel<\/strong> v\u00e0 h\u01b0\u1edbng d\u1eabn kh\u1eafc ph\u1ee5c theo nhi\u1ec1u c\u00e1ch kh\u00e1c nhau. H\u00e3y th\u1eed \u00e1p d\u1ee5ng ngay \u0111\u1ec3 c\u00f3 th\u1ec3 m\u1edf \u0111\u01b0\u1ee3c to\u00e0n b\u1ed9 c\u00e1c File b\u1ea1n c\u1ea7n d\u00f9ng nh\u00e9!<\/p>\n","protected":false},"excerpt":{"rendered":"

L\u1ed7i kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c File Excel di\u1ec5n ra r\u1ea5t ph\u1ed5 bi\u1ebfn v\u00e0 b\u1edfi nhi\u1ec1u nguy\u00ean nh\u00e2n kh\u00e1c nhau. \u0110\u1ec3 c\u00f3 th\u1ec3 x\u1eed l\u00fd nhanh nh\u1ea5t th\u00ec ng\u01b0\u1eddi d\u00f9ng c\u0169ng c\u1ea7n n\u1eafm \u0111\u01b0\u1ee3c r\u00f5 nguy\u00ean nh\u00e2n g\u00e2y n\u00ean t\u00ecnh tr\u1ea1ng n\u00e0y. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Ben Computer s\u1ebd \u0111\u01b0a ra nh\u1eefng nguy\u00ean nh\u00e2n v\u00e0 h\u01b0\u1edbng d\u1eabn […]<\/p>\n","protected":false},"author":29,"featured_media":45869,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[11],"tags":[],"class_list":["post-45217","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-van-phong"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/45217","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=45217"}],"version-history":[{"count":5,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/45217\/revisions"}],"predecessor-version":[{"id":48224,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/45217\/revisions\/48224"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/45869"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=45217"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=45217"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=45217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}