{"id":166787,"date":"2026-03-03T09:35:52","date_gmt":"2026-03-03T02:35:52","guid":{"rendered":"https:\/\/phongvu.vn\/cong-nghe\/?p=166787"},"modified":"2026-03-03T09:35:55","modified_gmt":"2026-03-03T02:35:55","slug":"sua-loi-mo-file-excel-khong-hien-ra-du-lieu","status":"publish","type":"post","link":"https:\/\/phongvu.vn\/cong-nghe\/sua-loi-mo-file-excel-khong-hien-ra-du-lieu\/","title":{"rendered":"5 c\u00e1ch s\u1eeda l\u1ed7i m\u1edf file Excel kh\u00f4ng hi\u1ec7n ra d\u1eef li\u1ec7u \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"\n

File Excel quan tr\u1ecdng tr\u1ed1ng r\u1ed7ng khi\u1ebfn b\u1ea1n ho\u1ea3ng lo\u1ea1n, \u0111\u1eebng lo, \u0111\u00e2y ch\u1ec9 l\u00e0 m\u1ed9t l\u1ed7i hi\u1ec3n th\u1ecb ph\u1ed5 bi\u1ebfn m\u00e0 h\u00e0ng ng\u00e0n ng\u01b0\u1eddi d\u00f9ng \u0111\u00e3 g\u1eb7p ph\u1ea3i. V\u1edbi v\u00e0i thao t\u00e1c \u0111\u01a1n gi\u1ea3n, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 t\u1ef1 kh\u1eafc ph\u1ee5c l\u1ed7i m\u1edf file Excel kh\u00f4ng hi\u1ec7n ra d\u1eef li\u1ec7u ngay t\u1ea1i nh\u00e0. Ch\u1ec9 c\u1ea7n \u00e1p d\u1ee5ng 5 m\u1eb9o nh\u1ecf m\u00e0 Phong V\u0169 Tech News<\/a> h\u01b0\u1edbng d\u1eabn d\u01b0\u1edbi \u0111\u00e2y, b\u1ea1n s\u1ebd nhanh ch\u00f3ng l\u1ea5y l\u1ea1i to\u00e0n b\u1ed9 th\u00f4ng tin trong t\u00edch t\u1eafc. <\/p>\n\n\n\n

\"5
5 c\u00e1ch s\u1eeda l\u1ed7i m\u1edf file Excel kh\u00f4ng hi\u1ec7n ra d\u1eef li\u1ec7u \u0111\u01a1n gi\u1ea3n (Ngu\u1ed3n: Internet) <\/figcaption><\/figure>\n\n\n\n

I. Nguy\u00ean nh\u00e2n ch\u00ednh khi\u1ebfn file Excel b\u1ecb tr\u1eafng ho\u1eb7c x\u00e1m<\/strong><\/h2>\n\n\n\n

L\u1ed7i m\u1edf file Excel kh\u00f4ng hi\u1ec7n ra d\u1eef li\u1ec7u c\u00f3 th\u1ec3 b\u1eaft ngu\u1ed3n t\u1eeb nhi\u1ec1u nguy\u00ean nh\u00e2n kh\u00e1c nhau, ph\u1ea7n l\u1edbn xu\u1ea5t ph\u00e1t t\u1eeb c\u00e1c v\u1ea5n \u0111\u1ec1 v\u1ec1 c\u1ea5u h\u00ecnh ph\u1ea7n m\u1ec1m. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 nguy\u00ean nh\u00e2n ch\u00ednh khi\u1ebfn file Excel b\u1ecb tr\u1eafng ho\u1eb7c x\u00e1m:<\/p>\n\n\n\n

1. T\u00ednh n\u0103ng Dynamic Data Exchange (DDE) \u0111ang b\u1eadt <\/strong><\/h3>\n\n\n\n

\u0110\u00e2y l\u00e0 nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn nh\u1ea5t d\u1eabn \u0111\u1ebfn l\u1ed7i m\u1edf file Excel kh\u00f4ng hi\u1ec7n ra d\u1eef li\u1ec7u. DDE l\u00e0 t\u00ednh n\u0103ng gi\u00fap truy\u1ec1n t\u1ea3i d\u1eef li\u1ec7u gi\u1eefa c\u00e1c \u1ee9ng d\u1ee5ng v\u00e0 khi t\u00ednh n\u0103ng n\u00e0y \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t, n\u00f3 s\u1ebd ch\u1eb7n l\u1ec7nh m\u1edf file t\u1eeb h\u1ec7 \u0111i\u1ec1u h\u00e0nh khi\u1ebfn Excel ch\u1ec9 m\u1edf \u1ee9ng d\u1ee5ng r\u1ed7ng m\u00e0 kh\u00f4ng t\u1ea3i d\u1eef li\u1ec7u. <\/p>\n\n\n\n

2. File ho\u1eb7c Sheet b\u1ecb \u1ea9n <\/strong><\/h3>\n\n\n\n

C\u00f3 th\u1ec3 b\u1ea1n \u0111\u00e3 v\u00f4 t\u00ecnh \u1ea9n (Hide) trang t\u00ednh ho\u1eb7c thi\u1ebft l\u1eadp ch\u1ebf \u0111\u1ed9 \u1ea9n n\u00ean m\u1edf file ch\u1ec9 th\u1ea5y m\u00e0n h\u00ecnh tr\u1eafng\/x\u00e1m. D\u1eef li\u1ec7u v\u1eabn c\u00f2n nh\u01b0ng kh\u00f4ng hi\u1ec3n th\u1ecb.<\/p>\n\n\n\n

3. T\u00ednh n\u0103ng t\u0103ng t\u1ed1c ph\u1ea7n c\u1ee9ng \u0111\u1ed3 h\u1ecda \u0111ang b\u1eadt <\/strong><\/h3>\n\n\n\n

Tr\u00ean m\u1ed9t s\u1ed1 m\u00e1y t\u00ednh s\u1eed d\u1ee5ng card \u0111\u1ed3 h\u1ecda c\u0169 ho\u1eb7c driver kh\u00f4ng t\u01b0\u01a1ng th\u00edch, n\u1ebfu b\u1eadt t\u00ednh n\u0103ng t\u0103ng t\u1ed1c ph\u1ea7n c\u1ee9ng \u0111\u1ed3 h\u1ecda (Hardware Graphics Acceleration) r\u1ea5t d\u1ec5 khi\u1ebfn Excel kh\u00f4ng render \u0111\u01b0\u1ee3c n\u1ed9i dung v\u00e0 d\u1eabn \u0111\u1ebfn v\u00f9ng l\u00e0m vi\u1ec7c b\u1ecb tr\u1eafng\/x\u00e1m. <\/p>\n\n\n\n

4. Add-ins (ti\u1ec7n \u00edch b\u1ed5 sung) b\u1ecb l\u1ed7i ho\u1eb7c xung \u0111\u1ed9t<\/strong><\/h3>\n\n\n\n

M\u1ed9t s\u1ed1 add-ins nh\u01b0 Power Query \u0111\u00e3 c\u0169, kh\u00f4ng t\u01b0\u01a1ng th\u00edch ho\u1eb7c b\u1ecb h\u1ecfng c\u00f3 th\u1ec3 g\u00e2y ra l\u1ed7i m\u1edf file Excel kh\u00f4ng hi\u1ec7n ra d\u1eef li\u1ec7u. <\/p>\n\n\n\n

5. File b\u1ecb h\u1ecfng do t\u1eaft m\u00e1y \u0111\u1ed9t ng\u1ed9t<\/strong><\/h3>\n\n\n\n

N\u1ebfu t\u1eaft m\u00e1y t\u00ednh<\/a> \u0111\u1ed9t ng\u1ed9t ho\u1eb7c m\u1ea5t \u0111i\u1ec7n, Excel \u0111ang ghi d\u1eef li\u1ec7u v\u00e0o file b\u1ecb c\u1eaft ngang s\u1ebd d\u1eabn \u0111\u1ebfn c\u1ea5u tr\u00fac file b\u1ecb gi\u00e1n \u0111o\u1ea1n. Khi m\u1edf file, Excel kh\u00f4ng load \u0111\u01b0\u1ee3c n\u1ed9i dung n\u00ean m\u00e0n h\u00ecnh s\u1ebd hi\u1ec3n th\u1ecb tr\u1eafng ho\u1eb7c x\u00e1m. <\/p>\n\n\n\n

\"Nguy\u00ean
Nguy\u00ean nh\u00e2n ch\u00ednh khi\u1ebfn file Excel b\u1ecb tr\u1eafng ho\u1eb7c x\u00e1m<\/figcaption><\/figure>\n\n\n\n

Tham kh\u1ea3o m\u1ed9t s\u1ed1 m\u1eabu laptop <\/a>v\u0103n phong v\u1edbi gi\u00e1 \u01b0u \u0111\u00e3i t\u1ea1i Phong V\u0169:<\/a><\/p>\n\n\n\n

<\/div><\/div>
<\/div><\/div>\n\n\n\n

II. T\u1eaft t\u00ednh n\u0103ng DDE<\/strong><\/h2>\n\n\n\n

B\u01b0\u1edbc 1:<\/strong> M\u1edf t\u1eadp tin Excel b\u1ecb l\u1ed7i > Ch\u1ecdn File <\/strong>tr\u00ean thanh c\u00f4ng c\u1ee5.<\/p>\n\n\n\n

B\u01b0\u1edbc 2:<\/strong> K\u00e9o xu\u1ed1ng cu\u1ed1i trang v\u00e0 ch\u1ecdn Options<\/strong>.<\/p>\n\n\n\n

B\u01b0\u1edbc 3:<\/strong> T\u1ea1i c\u1eeda s\u1ed5 Excel Options<\/strong>, ch\u1ecdn Advanced<\/strong> > T\u1ea1i m\u1ee5c General, b\u1ecf t\u00edch \u00f4 Ignore other applications that use Dynamic Data Exchange (DDE)<\/strong> > Ch\u1ecdn OK<\/strong>. <\/p>\n\n\n\n

\"B\u1ecf
B\u1ecf t\u00edch \u00f4 Ignore other applications that use Dynamic Data Exchange (DDE) trong c\u1eeda s\u1ed5 Excel Options <\/figcaption><\/figure>\n\n\n\n

III. Ki\u1ec3m tra xem File\/Sheet c\u00f3 b\u1ecb \u1ea9n (Hide) kh\u00f4ng<\/strong><\/h2>\n\n\n\n

B\u01b0\u1edbc 1:<\/strong> M\u1edf t\u1eadp tin Excel g\u1eb7p l\u1ed7i > Ch\u1ecdn View <\/strong>tr\u00ean thanh c\u00f4ng c\u1ee5 > Ch\u1ecdn Unhide<\/strong>. <\/p>\n\n\n\n

B\u01b0\u1edbc 2: <\/strong>T\u1ea1i c\u1eeda s\u1ed5 Unhide<\/strong>, danh s\u00e1ch c\u00e1c trang t\u00ednh \u0111ang b\u1ecb \u1ea9n s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb. H\u00e3y ch\u1ecdn trang t\u00ednh b\u1ea1n mu\u1ed1n xu\u1ea5t hi\u1ec7n tr\u00ean m\u00e0n h\u00ecnh > Ch\u1ecdn OK<\/strong>.<\/p>\n\n\n\n

\"B\u1ecf
B\u1ecf \u1ea9n trang t\u00ednh t\u1ea1i c\u1eeda s\u1ed5 Unhide<\/figcaption><\/figure>\n\n\n\n

IV. T\u1eaft t\u0103ng t\u1ed1c ph\u1ea7n c\u1ee9ng<\/strong><\/h2>\n\n\n\n

B\u01b0\u1edbc 1:<\/strong> Th\u1ef1c hi\u1ec7n t\u01b0\u01a1ng t\u1ef1 c\u00e1c thao t\u00e1c \u0111\u00e3 h\u01b0\u1edbng d\u1eabn trong b\u01b0\u1edbc 1 v\u00e0 b\u01b0\u1edbc 2 c\u1ee7a m\u1ee5c II T\u1eaft t\u00ednh n\u0103ng DDE. <\/strong><\/p>\n\n\n\n

B\u01b0\u1edbc 2:<\/strong> T\u1ea1i c\u1eeda s\u1ed5 Excel Options<\/strong>, ch\u1ecdn Advanced <\/strong>> T\u1ea1i m\u1ee5c Display<\/strong>, t\u00edch v\u00e0o \u00f4 Disable hardware graphics acceleration<\/strong> > Ch\u1ecdn OK<\/strong>. <\/p>\n\n\n\n

\"T\u00edch
T\u00edch v\u00e0o \u00f4 Disable hardware graphics acceleration t\u1ea1i m\u1ee5c Display trong c\u1eeda s\u1ed5 Excel Options <\/figcaption><\/figure>\n\n\n\n

V. V\u00f4 hi\u1ec7u h\u00f3a c\u00e1c Add-ins g\u00e2y xung \u0111\u1ed9t<\/strong><\/h2>\n\n\n\n

B\u01b0\u1edbc 1: <\/strong>Th\u1ef1c hi\u1ec7n t\u01b0\u01a1ng t\u1ef1 c\u00e1c thao t\u00e1c \u0111\u00e3 h\u01b0\u1edbng d\u1eabn trong b\u01b0\u1edbc 1 v\u00e0 b\u01b0\u1edbc 2 c\u1ee7a m\u1ee5c II T\u1eaft t\u00ednh n\u0103ng DDE. <\/strong><\/p>\n\n\n\n

B\u01b0\u1edbc 2:<\/strong> T\u1ea1i c\u1eeda s\u1ed5 Excel Options<\/strong>, ch\u1ecdn Add-ins<\/strong> > T\u1ea1i m\u1ee5c Manage<\/strong>, ch\u1ecdn Excel Add-ins <\/strong>> Ch\u1ecdn Go<\/strong>. <\/p>\n\n\n\n

B\u01b0\u1edbc 3:<\/strong> T\u1ea1i c\u1eeda s\u1ed5 Add-ins<\/strong>, b\u1ecf t\u00edch to\u00e0n b\u1ed9 trong b\u1ea3ng danh s\u00e1ch > Ch\u1ecdn OK<\/strong>. <\/p>\n\n\n\n

\"B\u1ecf
B\u1ecf t\u00edch to\u00e0n b\u1ed9 trong b\u1ea3ng danh s\u00e1ch t\u1ea1i c\u1eeda s\u1ed5 Add-ins<\/figcaption><\/figure>\n\n\n\n

VI. S\u1eed d\u1ee5ng t\u00ednh n\u0103ng “Open and Repair”<\/strong><\/h2>\n\n\n\n

B\u01b0\u1edbc 1:<\/strong> M\u1edf \u1ee9ng d\u1ee5ng Excel <\/strong>> Ch\u1ecdn File <\/strong>> Open <\/strong>> Browse<\/strong>.<\/p>\n\n\n\n

B\u01b0\u1edbc 2: <\/strong>T\u1ea1i c\u1eeda s\u1ed5 Open<\/strong>, nh\u1ea5p 1 l\u1ea7n v\u00e0o file b\u1ecb l\u1ed7i  > Ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng tam gi\u00e1c k\u1ebf b\u00ean n\u00fat Open<\/strong>. <\/p>\n\n\n\n

B\u01b0\u1edbc 3:<\/strong> Ch\u1ecdn Open and Repair<\/strong> > Ch\u1ecdn Repair<\/strong>.<\/p>\n\n\n\n

\"M\u1edf
M\u1edf file b\u1eb1ng Browse, sau \u0111\u00f3 ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng tam gi\u00e1c k\u1ebf b\u00ean n\u00fat Open. Cu\u1ed1i c\u00f9ng, ch\u1ecdn Open and Repair r\u1ed3i ch\u1ecdn Repair <\/figcaption><\/figure>\n\n\n\n

VII. T\u1ed5ng k\u1ebft<\/strong><\/h2>\n\n\n\n

V\u1eady l\u00e0 ch\u1ec9 v\u1edbi 5 c\u00e1ch \u0111\u01a1n gi\u1ea3n tr\u00ean, b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng kh\u1eafc ph\u1ee5c l\u1ed7i m\u1edf file Excel kh\u00f4ng hi\u1ec7n ra d\u1eef li\u1ec7u ngay t\u1ea1i nh\u00e0. H\u00e3y l\u01b0u b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 xem l\u1ea1i h\u01b0\u1edbng d\u1eabn khi t\u00ecnh hu\u1ed1ng t\u01b0\u01a1ng t\u1ef1 x\u1ea3y ra trong t\u01b0\u01a1ng lai nh\u00e9. Ch\u00fac b\u1ea1n nhanh ch\u00f3ng \u201cc\u1ee9u\u201d \u0111\u01b0\u1ee3c file quan tr\u1ecdng v\u00e0 ho\u00e0n th\u00e0nh c\u00f4ng vi\u1ec7c th\u1eadt t\u1ed1t. \u0110\u1eebng qu\u00ean theo d\u00f5i nh\u1eefng b\u00e0i vi\u1ebft ti\u1ebfp theo c\u1ee7a Phong V\u0169 Tech News \u0111\u1ec3 c\u1eadp nh\u1eadt th\u00f4ng tin c\u00f4ng ngh\u1ec7 m\u1edbi nh\u1ea5t. <\/p>\n\n\n\n

B\u00e0i vi\u1ebft li\u00ean quan:<\/strong><\/p>\n\n\n\n