{"id":11187,"date":"2025-01-15T02:00:53","date_gmt":"2025-01-15T02:00:53","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/sua-loi-excel-khong-the-tao-moi-va-su-dung-vung-du-lieu-qua-phuc-tap\/"},"modified":"2025-01-15T02:00:53","modified_gmt":"2025-01-15T02:00:53","slug":"sua-loi-excel-khong-the-tao-moi-va-su-dung-vung-du-lieu-qua-phuc-tap","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/sua-loi-excel-khong-the-tao-moi-va-su-dung-vung-du-lieu-qua-phuc-tap\/","title":{"rendered":"S\u1eeda l\u1ed7i \u201cExcel kh\u00f4ng th\u1ec3 t\u1ea1o m\u1edbi v\u00e0 s\u1eed d\u1ee5ng v\u00f9ng d\u1eef li\u1ec7u qu\u00e1 ph\u1ee9c t\u1ea1p\u201d"},"content":{"rendered":"
\n

M\u1ed9t trong s\u1ed1 nh\u1eefng l\u1ed7i g\u00e2y kh\u00f3 ch\u1ecbu nh\u1ea5t cho ng\u01b0\u1eddi d\u00f9ng Excel \u0111\u00f3 l\u00e0 l\u1ed7i kh\u00f4ng th\u1ec3 t\u1ea1o m\u1edbi hay s\u1eed d\u1ee5ng v\u00f9ng d\u1eef li\u1ec7u qu\u00e1 ph\u1ee9c t\u1ea1p<\/a>. Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n t\u00ecm hi\u1ec3u nguy\u00ean nh\u00e2n v\u00ec sao l\u1ed7i x\u1ea3y ra v\u00e0 bi\u1ec7n ph\u00e1p ch\u1eefa tr\u1ecb d\u1ee9t \u0111i\u1ec3m c\u0103n b\u1ec7nh n\u00e0y.<\/p>\n

<\/p>\n

Bi\u1ec3u hi\u1ec7n<\/strong><\/p>\n

L\u1ed7i tr\u00ean th\u01b0\u1eddng xuy\u00ean xu\u1ea5t hi\u1ec7n trong nh\u1eefng t\u1ec7p Excel c\u00f3 l\u01b0\u1ee3ng d\u1eef li\u1ec7u l\u1edbn c\u1ea7n s\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc d\u1eef li\u1ec7u filter. V\u00ed d\u1ee5 ch\u1eb3ng h\u1ea1n nh\u01b0 d\u1eef li\u1ec7u doanh thu b\u00e1n h\u00e0ng to\u00e0n c\u1ea7u c\u1ee7a 1 c\u00f4ng ty (theo qu\u1ed1c gia, theo khu v\u1ef1c, theo qu\u00fd, v.v.). Gi\u1ea3 s\u1eed b\u1ea1n c\u1ea7n truy c\u1eadp th\u00f4ng tin v\u1ec1 doanh s\u1ed1 b\u00e1n h\u00e0ng qu\u00fd 3 t\u1ea1i khu v\u1ef1c B\u1eafc M\u1ef9 c\u1ee7a 1 s\u1ea3n ph\u1ea9m b\u1ea5t k\u1ef3. D\u1ef1a v\u00e0o \u0111\u00f3 b\u1ea1n \u00e1p d\u1ee5ng b\u1ed9 l\u1ecdc v\u1edbi c\u00e1c ti\u00eau ch\u00ed nh\u01b0 tr\u00ean. Ti\u1ebfp \u0111\u1ebfn b\u1ea1n b\u00f4i \u0111en nh\u1eefng \u00f4 t\u00ednh c\u1ea7n s\u1eed d\u1ee5ng (t\u1ed5 h\u1ee3p ph\u00edm Alt+D\u1ea5u ch\u1ea5m ph\u1ea9y) v\u00e0 b\u1ea5m ti\u1ebfp Ctrl+(-) ho\u1eb7c \u0111\u01a1n gi\u1ea3n l\u00e0 x\u00f3a b\u1edbt h\u00e0ng \u0111i. K\u1ebft qu\u1ea3 s\u1ebd xu\u1ea5t hi\u1ec7n 1 th\u00f4ng b\u00e1o l\u1ed7i c\u00f3 d\u1ea1ng nh\u01b0 h\u00ecnh d\u01b0\u1edbi:<\/p>\n

<\/p>\n

\u201cMicrosoft excel cannot create or use the data range reference\u00a0because it is too complex, Try one or more of the following:\u201d<\/em><\/p>\n

V\u1eady v\u1ea5n \u0111\u1ec1 n\u1eb1m \u1edf \u0111\u00e2u? N\u00f3i m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n, v\u1ea5n \u0111\u1ec1 n\u1eb1m \u1edf ch\u1ed7 b\u1ea1n \u0111ang s\u1eed d\u1ee5ng m\u1ed9t b\u1ea3ng t\u00ednh v\u1edbi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp qu\u00e1 l\u1ed9n x\u1ed9n ho\u1eb7c theo m\u1ed9t th\u1ee9 t\u1ef1 kh\u00f4ng r\u00f5 r\u00e0ng.<\/p>\n

Nguy\u00ean nh\u00e2n<\/strong><\/p>\n

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

Khi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp l\u1ed9n x\u1ed9n th\u00ec t\u1ed1c \u0111\u1ed9 x\u1eed l\u00fd v\u00e0 ph\u1ea3n h\u1ed3i c\u1ee7a trang t\u00ednh workbook tr\u1edf n\u00ean b\u1ecb tr\u00ec tr\u1ec7. \u0110i\u1ec1u n\u00e0y c\u0169ng gi\u1ed1ng nh\u01b0 b\u1ea1n c\u00f3 1 gi\u00e1 s\u00e1ch ng\u0103n n\u1eafp th\u00ec vi\u1ec7c ch\u1ecdn l\u1ecdc s\u00e1ch \u0111\u1ec3 l\u1ea5y ra \u0111\u1ecdc s\u1ebd d\u1ec5 d\u00e0ng h\u01a1n r\u1ea5t nhi\u1ec1u. T\u00f3m l\u1ea1i, khi b\u1ea1n x\u00f3a \u0111i m\u1ed9t v\u00e0i d\u00f2ng d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh th\u00ec Excel tr\u01b0\u1edbc h\u1ebft s\u1ebd ph\u1ea3i th\u1ef1c hi\u1ec7n quy tr\u00ecnh Search to\u00e0n b\u1ed9 d\u00f2ng \u0111\u00f3 \u0111\u1ec3 r\u00e0 so\u00e1t l\u1ea1i d\u1eef li\u1ec7u sau \u0111\u00f3 m\u1edbi th\u1ef1c hi\u1ec7n l\u1ec7nh x\u00f3a, v\u00e0 qu\u00e1 tr\u00ecnh n\u00e0y s\u1ebd l\u1eb7p l\u1ea1i t\u01b0\u01a1ng t\u1ef1 cho c\u00e1c d\u00f2ng kh\u00e1c. Vi\u1ec7c n\u00e0y s\u1ebd ti\u00eau t\u1ed1n kh\u00e1 nhi\u1ec1u t\u00e0i nguy\u00ean m\u00e1y t\u00ednh c\u0169ng nh\u01b0 c\u1ea7n t\u1ed1c \u0111\u1ed9 x\u1eed l\u00fd c\u1ee7a m\u00e1y ph\u1ea3i r\u1ea5t nhanh.<\/p>\n

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

Gi\u1ea3i ph\u00e1p r\u1ea5t \u0111\u01a1n gi\u1ea3n \u0111\u00f3 l\u00e0 b\u1ea1n c\u1ea7n ph\u1ea3i s\u1eafp x\u1ebfp th\u1ee9 t\u1ef1 (Sort) d\u1eef li\u1ec7u l\u1ea1i, theo th\u1ee9 t\u1ef1 t\u1eeb A->Z ho\u1eb7c Z->A.<\/p>\n

Vi\u1ec7c n\u00e0y s\u1ebd gi\u00fap cho d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n tr\u1edf n\u00ean g\u1ecdn g\u00e0ng h\u01a1n v\u00e0 t\u1ed1c \u0111\u1ed9 x\u1eed l\u00fd c\u0169ng s\u1ebd nhanh h\u01a1n.<\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11188,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11187","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\/11187","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=11187"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11187\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11188"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}