{"id":1523,"date":"2026-08-28T14:52:10","date_gmt":"2026-08-28T07:52:10","guid":{"rendered":"\/thu-vien\/?post_type=ht_kb&p=1523"},"modified":"2026-10-16T10:08:16","modified_gmt":"2026-10-16T03:08:16","slug":"mot-so-van-de-thuong-gap-khi-nhap-khau-excel-tren-phan-mem","status":"publish","type":"ht_kb","link":"\/thu-vien\/knowledge-base\/mot-so-van-de-thuong-gap-khi-nhap-khau-excel-tren-phan-mem\/","title":{"rendered":"M\u1ed9t s\u1ed1 v\u1ea5n \u0111\u1ec1 th\u01b0\u1eddng g\u1eb7p khi nh\u1eadp kh\u1ea9u excel tr\u00ean ph\u1ea7n m\u1ec1m"},"content":{"rendered":"

1. T\u1ed5ng quan<\/span><\/h3>\n

B\u00e0i vi\u1ebft n\u00e0y gi\u00fap anh\/ch\u1ecb nh\u1eadn bi\u1ebft v\u00e0 x\u1eed l\u00fd m\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u t\u1eeb file Excel v\u00e0o ph\u1ea7n m\u1ec1m.<\/span><\/p>\n

2. M\u1ed9t v\u1ea5n \u0111\u1ec1 th\u01b0\u1eddng g\u1eb7p<\/span><\/h3>\n

2.1. Nh\u1eadp kh\u1ea9u b\u00e1o l\u1ed7i “T\u1ec7p \u0111\u00e3 ch\u1ecdn kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u” ho\u1eb7c b\u00e1o l\u1ed7i “Exception” ph\u1ea3i l\u00e0m th\u1ebf n\u00e0o?<\/span><\/h4>\n

Tr\u1ea3 l\u1eddi:<\/strong><\/span><\/p>\n

Nguy\u00ean nh\u00e2n:<\/strong> Khi t\u1ea3i file m\u1eabu Excel v\u1ec1, file c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng ph\u00e1t sinh th\u00eam m\u1ed9t sheet tr\u1ed1ng v\u00e0 b\u1ecb \u1ea9n<\/strong>. Khi nh\u1eadp kh\u1ea9u, ph\u1ea7n m\u1ec1m \u0111\u1ecdc nh\u1ea7m sheet tr\u1ed1ng n\u00e0y n\u00ean b\u00e1o l\u1ed7i “T\u1ec7p \u0111\u00e3 ch\u1ecdn kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u” <\/strong>ho\u1eb7c ” Exception<\/strong> “.<\/span><\/p>\n

Gi\u1ea3i ph\u00e1p:<\/strong><\/span><\/p>\n

    \n
  • C\u00e1ch 1:<\/strong> Chuy\u1ec3n sang m\u00e1y t\u00ednh kh\u00e1c, t\u1ea3i l\u1ea1i file m\u1eabu Excel<\/strong>, sau \u0111\u00f3 sao ch\u00e9p d\u1eef li\u1ec7u t\u1eeb file c\u0169 sang file m\u1eabu m\u1edbi t\u1ea3i v\u00e0 th\u1ef1c hi\u1ec7n nh\u1eadp kh\u1ea9u l\u1ea1i.<\/span><\/li>\n
  • C\u00e1ch 2:<\/strong> M\u1edf file Excel, nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o t\u00ean sheet<\/strong> \u1edf g\u00f3c tr\u00e1i b\u00ean d\u01b0\u1edbi, ch\u1ecdn Unhide<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb sheet \u0111ang b\u1ecb \u1ea9n. X\u00f3a sheet tr\u1ed1ng<\/strong> n\u00e0y, sau \u0111\u00f3 l\u01b0u file v\u00e0 th\u1ef1c hi\u1ec7n nh\u1eadp kh\u1ea9u l\u1ea1i.<\/span><\/li>\n<\/ul>\n

    2.2. Thao t\u00e1c tr\u00ean file m\u1eabu Excel (v\u00ed d\u1ee5 File ki\u1ec3m k\u00ea s\u00e1ch) b\u00e1o l\u1ed7i “The cell or chart you’re trying to change is on a protected sheet…” ph\u1ea3i l\u00e0m th\u1ebf n\u00e0o?<\/span><\/h4>\n

    Tr\u1ea3 l\u1eddi<\/strong><\/span><\/p>\n

    Nguy\u00ean nh\u00e2n:<\/strong> Sheet Excel \u0111ang \u0111\u01b0\u1ee3c b\u1eadt ch\u1ebf \u0111\u1ed9 Protect Sheet (b\u1ea3o v\u1ec7 trang t\u00ednh)<\/strong> n\u00ean m\u1ed9t s\u1ed1 \u00f4 ho\u1eb7c n\u1ed9i dung tr\u00ean sheet b\u1ecb kh\u00f3a, kh\u00f4ng cho ph\u00e9p ch\u1ec9nh s\u1eeda.<\/span><\/p>\n

    Gi\u1ea3i ph\u00e1p:<\/strong> Anh\/ch\u1ecb th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\n

      \n
    1. M\u1edf file Excel, nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o t\u00ean Sheet c\u1ea7n ch\u1ec9nh s\u1eeda<\/strong> \u1edf g\u00f3c tr\u00e1i b\u00ean d\u01b0\u1edbi.<\/span><\/li>\n
    2. Ch\u1ecdn Unprotect Sheet<\/strong> \u0111\u1ec3 b\u1ecf ch\u1ebf \u0111\u1ed9 b\u1ea3o v\u1ec7.<\/span><\/li>\n
    3. Th\u1ef1c hi\u1ec7n ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u tr\u00ean Sheet.<\/span><\/li>\n<\/ol>\n

      2.3. T\u1ea3i file Excel l\u00ean ph\u1ea7n m\u1ec1m \u0111\u1ec3 nh\u1eadp kh\u1ea9u nh\u01b0ng kh\u00f4ng th\u1ea5y n\u00fat Ti\u1ebfp t\u1ee5c th\u00ec l\u00e0m th\u1ebf n\u00e0o?<\/span><\/h4>\n

      Tr\u1ea3 l\u1eddi:<\/strong><\/span><\/p>\n

      Sau khi t\u1ea3i file Excel l\u00ean ph\u1ea7n m\u1ec1m, n\u1ebfu kh\u00f4ng th\u1ea5y n\u00fat Ti\u1ebfp t\u1ee5c<\/strong> \u0111\u1ec3 th\u1ef1c hi\u1ec7n nh\u1eadp kh\u1ea9u, c\u00f3 th\u1ec3 do k\u00edch th\u01b0\u1edbc m\u00e0n h\u00ecnh hi\u1ec3n th\u1ecb qu\u00e1 l\u1edbn khi\u1ebfn n\u00fat Ti\u1ebfp t\u1ee5c \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i b\u1ecb thanh Taskbar che khu\u1ea5t<\/strong>.<\/span><\/p>\n

      Anh\/ch\u1ecb th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\n

        \n
      1. Nh\u1ea5n Ctrl + ph\u00edm – (d\u1ea5u tr\u1eeb)<\/strong> \u0111\u1ec3 thu nh\u1ecf m\u00e0n h\u00ecnh.<\/span><\/li>\n
      2. Nh\u1ea5n Ti\u1ebfp t\u1ee5c<\/strong> \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i m\u00e0n h\u00ecnh \u0111\u1ec3 chuy\u1ec3n sang b\u01b0\u1edbc ti\u1ebfp theo v\u00e0 ho\u00e0n t\u1ea5t nh\u1eadp kh\u1ea9u file Excel.<\/span><\/li>\n<\/ol>\n

        2.4. <\/strong>Khi nh\u1eadp kh\u1ea9u s\u00e1ch, ph\u1ea7n m\u1ec1m b\u00e1o l\u1ed7i \u201cKh\u00f4ng th\u1ec3 \u0111\u1ed5i lo\u1ea1i s\u00e1ch c\u1ee7a bi\u00ean m\u1ee5c \u0111\u00e3 c\u00f3 trong h\u1ec7 th\u1ed1ng. Vui l\u00f2ng \u0111\u1ed5i lo\u1ea1i s\u00e1ch t\u1ea1i h\u1ec7 th\u1ed1ng\u201d th\u00ec x\u1eed l\u00fd th\u1ebf n\u00e0o?<\/span><\/h4>\n

        Tr\u1ea3 l\u1eddi:<\/strong><\/span><\/p>\n

        Nguy\u00ean nh\u00e2n:<\/strong> S\u00e1ch \u0111\u00e3 c\u00f3 bi\u00ean m\u1ee5c tr\u00ean h\u1ec7 th\u1ed1ng nh\u01b0ng lo\u1ea1i s\u00e1ch trong bi\u00ean m\u1ee5c kh\u00f4ng kh\u1edbp v\u1edbi lo\u1ea1i s\u00e1ch \u0111\u01b0\u1ee3c khai b\u00e1o trong file Excel nh\u1eadp kh\u1ea9u.<\/span><\/p>\n

        Gi\u1ea3i ph\u00e1p:<\/strong> Anh\/ch\u1ecb th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n

        B\u01b0\u1edbc 1:<\/strong> V\u00e0o H\u1ec7 th\u1ed1ng\\<\/strong>t\u1ea1i m\u1ee5c Danh m\u1ee5c\\<\/strong>nh\u1ea5n\u00a0Bi\u00ean m\u1ee5c.<\/strong><\/span><\/p>\n

        B\u01b0\u1edbc 2:<\/strong> T\u00ecm bi\u00ean m\u1ee5c \u0111ang b\u1ecb b\u00e1o l\u1ed7i, k\u00edch \u0111\u00fap v\u00e0o bi\u00ean m\u1ee5c \u0111\u1ec3 ki\u1ec3m tra lo\u1ea1i s\u00e1ch \u0111\u00e3 khai b\u00e1o.<\/span><\/p>\n

        B\u01b0\u1edbc 3: <\/strong>\u0110i\u1ec1u ch\u1ec9nh lo\u1ea1i s\u00e1ch theo m\u1ed9t trong hai tr\u01b0\u1eddng h\u1ee3p:<\/span><\/p>\n

          \n
        • N\u1ebfu lo\u1ea1i s\u00e1ch trong bi\u00ean m\u1ee5c kh\u00f4ng \u0111\u00fang:<\/strong> S\u1eeda l\u1ea1i lo\u1ea1i s\u00e1ch trong bi\u00ean m\u1ee5c cho \u0111\u00fang, sau \u0111\u00f3 nh\u1eadp kh\u1ea9u l\u1ea1i file Excel.<\/span><\/li>\n
        • N\u1ebfu lo\u1ea1i s\u00e1ch trong bi\u00ean m\u1ee5c \u0111\u00e3 \u0111\u00fang:<\/strong> S\u1eeda lo\u1ea1i s\u00e1ch trong file Excel cho kh\u1edbp v\u1edbi lo\u1ea1i s\u00e1ch trong bi\u00ean m\u1ee5c, sau \u0111\u00f3 nh\u1eadp kh\u1ea9u l\u1ea1i.<\/span><\/li>\n<\/ul>\n

          2.5. Nh\u1eadp kh\u1ea9u s\u00e1ch b\u00e1o b\u00e1o dung l\u01b0\u1ee3ng file Excel v\u01b0\u1ee3t qu\u00e1 5 MB th\u00ec ph\u1ea3i l\u00e0m th\u1ebf n\u00e0o?<\/span><\/h4>\n

          Tr\u1ea3 l\u1eddi:<\/strong> <\/span><\/p>\n

          Hi\u1ec7n t\u1ea1i, ph\u1ea7n m\u1ec1m ch\u1ec9 h\u1ed7 tr\u1ee3 file Excel nh\u1eadp kh\u1ea9u c\u00f3 dung l\u01b0\u1ee3ng d\u01b0\u1edbi 5 MB.<\/span><\/p>\n

          Tr\u01b0\u1eddng h\u1ee3p file nh\u1eadp kh\u1ea9u v\u01b0\u1ee3t qu\u00e1 5 MB, anh\/ch\u1ecb t\u00e1ch file th\u00e0nh nhi\u1ec1u file nh\u1ecf, m\u1ed7i file c\u00f3 dung l\u01b0\u1ee3ng d\u01b0\u1edbi 5 MB, sau \u0111\u00f3 th\u1ef1c hi\u1ec7n nh\u1eadp kh\u1ea9u l\u1ea1i t\u1eebng file.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

          1. T\u1ed5ng quan B\u00e0i vi\u1ebft n\u00e0y gi\u00fap anh\/ch\u1ecb nh\u1eadn bi\u1ebft v\u00e0 x\u1eed l\u00fd m\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u t\u1eeb file Excel v\u00e0o ph\u1ea7n m\u1ec1m. 2. M\u1ed9t v\u1ea5n \u0111\u1ec1 th\u01b0\u1eddng g\u1eb7p 2.1. Nh\u1eadp kh\u1ea9u b\u00e1o l\u1ed7i “T\u1ec7p \u0111\u00e3 ch\u1ecdn kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u” ho\u1eb7c b\u00e1o l\u1ed7i…<\/p>\n","protected":false},"author":11,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[],"ht-kb-tag":[],"class_list":["post-1523","ht_kb","type-ht_kb","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"\/thu-vien\/wp-json\/wp\/v2\/ht-kb\/1523","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/thu-vien\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/thu-vien\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/thu-vien\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"\/thu-vien\/wp-json\/wp\/v2\/comments?post=1523"}],"version-history":[{"count":3,"href":"\/thu-vien\/wp-json\/wp\/v2\/ht-kb\/1523\/revisions"}],"predecessor-version":[{"id":2197,"href":"\/thu-vien\/wp-json\/wp\/v2\/ht-kb\/1523\/revisions\/2197"}],"wp:attachment":[{"href":"\/thu-vien\/wp-json\/wp\/v2\/media?parent=1523"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/thu-vien\/wp-json\/wp\/v2\/ht-kb-category?post=1523"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/thu-vien\/wp-json\/wp\/v2\/ht-kb-tag?post=1523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}