{"id":4835,"date":"2025-11-17T16:00:33","date_gmt":"2025-11-17T09:00:33","guid":{"rendered":"https:\/\/autofillform.com\/blog\/nguyen-nhan-va-cach-sua-loi-circular-reference-trong-excel\/"},"modified":"2025-11-17T16:00:33","modified_gmt":"2025-11-17T09:00:33","slug":"nguyen-nhan-va-cach-sua-loi-circular-reference-trong-excel","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/nguyen-nhan-va-cach-sua-loi-circular-reference-trong-excel\/","title":{"rendered":"Nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i Circular Reference trong Excel"},"content":{"rendered":"
\n
\u00a0<\/div>\n

L\u1ed7i Circular Reference trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng l\u1ed7i ph\u1ed5 bi\u1ebfn khi\u1ebfn ng\u01b0\u1eddi d\u00f9ng g\u1eb7p kh\u00f3 kh\u0103n khi t\u00ednh to\u00e1n d\u1eef li\u1ec7u. Khi c\u00f4ng th\u1ee9c t\u1ef1 tham chi\u1ebfu \u0111\u1ebfn ch\u00ednh \u00f4 ch\u1ee9a n\u00f3, Excel s\u1ebd kh\u00f4ng th\u1ec3 x\u1eed l\u00fd v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 sai ho\u1eb7c b\u1eb1ng 0. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 nguy\u00ean nh\u00e2n, c\u00e1ch nh\u1eadn bi\u1ebft v\u00e0 kh\u1eafc ph\u1ee5c l\u1ed7i v\u00f2ng l\u1eb7p n\u00e0y m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/p>\n

\"GiaoNguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i Circular Reference trong Excel<\/em><\/p>\n

\n

1. L\u1ed7i Circular Reference l\u00e0 g\u00ec?<\/h2>\n<\/div>\n

L\u1ed7i Circular References trong Excel l\u00e0 t\u00ecnh hu\u1ed1ng m\u1ed9t \u00f4 c\u00f4ng th\u1ee9c tham chi\u1ebfu tr\u1ef1c ti\u1ebfp ho\u1eb7c gi\u00e1n ti\u1ebfp \u0111\u1ebfn ch\u00ednh n\u00f3. Khi \u0111\u00f3, Excel kh\u00f4ng th\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb ch\u00ednh x\u00e1c v\u00ec ph\u00e9p t\u00ednh t\u1ea1o th\u00e0nh v\u00f2ng l\u1eb7p v\u00f4 t\u1eadn.<\/p>\n

C\u1ee5 th\u1ec3, n\u1ebfu b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c m\u00e0 trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n l\u1ea1i g\u1ecdi \u0111\u1ebfn ch\u00ednh \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c \u0111\u00f3, Excel s\u1ebd b\u00e1o l\u1ed7i \u201cThere are one or more circular references where a formula refers to its own cell either directly or indirectly…<\/strong>\u201d v\u00e0 th\u01b0\u1eddng tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 b\u1eb1ng 0 ho\u1eb7c kh\u00f4ng th\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c.<\/p>\n

\"Th\u00f4ngL\u1ed7i Circular Reference trong Excel<\/em><\/p>\n

\n

2. Nguy\u00ean nh\u00e2n g\u00e2y ra l\u1ed7i Circular Reference trong Excel<\/h2>\n<\/div>\n

L\u1ed7i v\u00f2ng l\u1eb7p th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n khi c\u00f4ng th\u1ee9c trong m\u1ed9t \u00f4 l\u1ea1i tham chi\u1ebfu \u0111\u1ebfn ch\u00ednh \u00f4 \u0111\u00f3, khi\u1ebfn Excel kh\u00f4ng th\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c th\u1ee9 t\u1ef1 t\u00ednh to\u00e1n.<\/p>\n

V\u00ed d\u1ee5: <\/strong>B\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng c\u1ee7a hai \u00f4 F1 v\u00e0 F2 r\u1ed3i hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 t\u1ea1i \u00f4 F3. Tuy nhi\u00ean, n\u1ebfu c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c nh\u1eadp l\u00e0 =F1+F2+F3, \u00f4 F3 \u0111\u00e3 v\u00f4 t\u00ecnh t\u1ef1 tham chi\u1ebfu \u0111\u1ebfn ch\u00ednh n\u00f3. L\u00fac n\u00e0y, Excel r\u01a1i v\u00e0o v\u00f2ng l\u1eb7p v\u00f4 h\u1ea1n v\u00e0 kh\u00f4ng th\u1ec3 x\u1eed l\u00fd k\u1ebft qu\u1ea3, d\u1eabn \u0111\u1ebfn gi\u00e1 tr\u1ecb hi\u1ec3n th\u1ecb b\u1eb1ng 0 ho\u1eb7c b\u00e1o l\u1ed7i Circular Reference.<\/p>\n

Hi\u1ec3u \u0111\u01a1n gi\u1ea3n, nguy\u00ean nh\u00e2n ch\u00ednh l\u00e0 do ng\u01b0\u1eddi d\u00f9ng v\u00f4 t\u00ecnh t\u1ea1o m\u1ed1i li\u00ean k\u1ebft ng\u01b0\u1ee3c trong c\u00f4ng th\u1ee9c, khi\u1ebfn Excel \u201ckh\u00f4ng bi\u1ebft b\u1eaft \u0111\u1ea7u t\u00ednh t\u1eeb \u0111\u00e2u\u201d.<\/p>\n

\n

3. C\u00e1ch s\u1eeda l\u1ed7i Circular Reference trong Excel<\/h2>\n<\/div>\n
\n

3.1. V\u00f2ng l\u1eb7p do v\u00f4 \u00fd<\/h3>\n<\/div>\n

\u0110\u00e2y l\u00e0 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi ng\u01b0\u1eddi d\u00f9ng v\u00f4 t\u00ecnh ch\u1ecdn ch\u00ednh \u00f4 ch\u1ee9a k\u1ebft qu\u1ea3 \u0111\u1ec3 \u0111\u01b0a v\u00e0o c\u00f4ng th\u1ee9c t\u00ednh, khi\u1ebfn Excel kh\u00f4ng th\u1ec3 x\u1eed l\u00fd v\u00ec c\u00f4ng th\u1ee9c t\u1ef1 tham chi\u1ebfu \u0111\u1ebfn ch\u00ednh n\u00f3. K\u1ebft qu\u1ea3 l\u00e0 ph\u00e9p t\u00ednh b\u1ecb l\u1eb7p v\u00f4 t\u1eadn v\u00e0 kh\u00f4ng hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb mong mu\u1ed1n.<\/p>\n

C\u00e1ch x\u1eed l\u00fd l\u1ed7i v\u00f2ng l\u1eb7p v\u00f4 \u00fd:<\/strong><\/p>\n

B\u01b0\u1edbc 1: <\/strong>M\u1edf th\u1ebb Formulas<\/strong> tr\u00ean thanh c\u00f4ng c\u1ee5 \u0111\u1ec3 truy c\u1eadp c\u00e1c t\u00f9y ch\u1ecdn ki\u1ec3m tra c\u00f4ng th\u1ee9c.<\/p>\n

\"M\u1edfM\u1edf th\u1ebb Formulas tr\u00ean thanh c\u00f4ng c\u1ee5 \u0111\u1ec3 truy c\u1eadp c\u00e1c t\u00f9y ch\u1ecdn ki\u1ec3m tra c\u00f4ng th\u1ee9c<\/em><\/p>\n

B\u01b0\u1edbc 2:<\/strong> Trong nh\u00f3m Formula Auditing<\/strong>, ch\u1ecdn Error Checking<\/strong>.<\/p>\n

\"M\u1edfTrong nh\u00f3m Formula Auditing, ch\u1ecdn Error Checking<\/em><\/p>\n

B\u01b0\u1edbc 3: <\/strong>T\u1ea1i danh s\u00e1ch m\u1edf r\u1ed9ng, ch\u1ecdn Circular References<\/strong>. Excel s\u1ebd hi\u1ec3n th\u1ecb \u00f4 \u0111ang b\u1ecb l\u1ed7i, v\u00ed d\u1ee5 \u00f4 D4, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o \u0111\u1ec3 chuy\u1ec3n \u0111\u1ebfn v\u1ecb tr\u00ed \u0111\u00f3.<\/p>\n

\"Ch\u1ecdnT\u1ea1i danh s\u00e1ch m\u1edf r\u1ed9ng, ch\u1ecdn Circular References<\/em><\/p>\n

B\u01b0\u1edbc 4: <\/strong>Xem l\u1ea1i v\u00e0 ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c, c\u00f3 th\u1ec3 l\u00e0 x\u00f3a ph\u1ea7n tham chi\u1ebfu sai ho\u1eb7c di chuy\u1ec3n c\u00f4ng th\u1ee9c sang \u00f4 kh\u00e1c. Khi c\u00f4ng th\u1ee9c kh\u00f4ng c\u00f2n t\u1ef1 tham chi\u1ebfu, l\u1ed7i s\u1ebd t\u1ef1 \u0111\u1ed9ng bi\u1ebfn m\u1ea5t.<\/p>\n

\"\u00d4Xem l\u1ea1i v\u00e0 ch\u1ec9nh s\u1eeda c\u00f4ng th\u1ee9c \u0111\u1ec3 s\u1eeda l\u1ed7i v\u00f2ng l\u1eb7p<\/em><\/p>\n

Xem th\u00eam: <\/strong>T\u00ecm hi\u1ec3u nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i #N\/A trong Excel hi\u1ec7u qu\u1ea3<\/div>\n
\n

3.2. Cho ph\u00e9p s\u1eed d\u1ee5ng v\u00f2ng l\u1eb7p (c\u1ed1 \u00fd)<\/h3>\n<\/div>\n

Trong m\u1ed9t s\u1ed1 t\u00ecnh hu\u1ed1ng \u0111\u1eb7c bi\u1ec7t, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 t\u1eadn d\u1ee5ng t\u00ednh n\u0103ng v\u00f2ng l\u1eb7p \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh l\u1eb7p \u0111i l\u1eb7p l\u1ea1i cho \u0111\u1ebfn khi \u0111\u1ea1t k\u1ebft qu\u1ea3 mong mu\u1ed1n. Khi \u0111\u00f3, thay v\u00ec xem \u0111\u00e2y l\u00e0 l\u1ed7i, b\u1ea1n c\u1ea7n b\u1eadt ch\u1ebf \u0111\u1ed9 cho ph\u00e9p t\u00ednh v\u00f2ng l\u1eb7p v\u00e0 gi\u1edbi h\u1ea1n s\u1ed1 l\u1ea7n l\u1eb7p h\u1ee3p l\u00fd \u0111\u1ec3 tr\u00e1nh sai s\u1ed1.<\/p>\n

C\u00e1ch b\u1eadt v\u00e0 thi\u1ebft l\u1eadp v\u00f2ng l\u1eb7p trong Excel:<\/strong><\/p>\n

B\u01b0\u1edbc 1:<\/strong> M\u1edf file Excel<\/strong>, ch\u1ecdn th\u1ebb File<\/strong> tr\u00ean thanh c\u00f4ng c\u1ee5.<\/p>\n

\"Ch\u1ecdnM\u1edf file Excel, ch\u1ecdn th\u1ebb File tr\u00ean thanh c\u00f4ng c\u1ee5<\/em><\/p>\n

B\u01b0\u1edbc 2:<\/strong> T\u00ecm v\u00e0 ch\u1ecdn v\u00e0o m\u1ee5c Options<\/strong>.<\/p>\n

\"M\u1ee5cT\u00ecm v\u00e0 ch\u1ecdn v\u00e0o m\u1ee5c Options<\/em><\/p>\n

B\u01b0\u1edbc 3:<\/strong> Trong c\u1eeda s\u1ed5 Excel Options<\/strong>, ch\u1ecdn m\u1ee5c Formulas<\/strong>.<\/p>\n

\"C\u00e0iTrong c\u1eeda s\u1ed5 Excel Options, ch\u1ecdn m\u1ee5c Formulas<\/em><\/p>\n

B\u01b0\u1edbc 4: <\/strong>Trong ph\u1ea7n Calculation options<\/strong>, \u0111\u00e1nh d\u1ea5u ch\u1ecdn Enable iterative calculation<\/strong> \u0111\u1ec3 k\u00edch ho\u1ea1t ch\u1ebf \u0111\u1ed9 t\u00ednh l\u1eb7p.<\/p>\n

\"B\u1eadt\u0110\u00e1nh d\u1ea5u t\u00edch v\u00e0o Enable iterative calculation \u0111\u1ec3 k\u00edch ho\u1ea1t ch\u1ebf \u0111\u1ed9 t\u00ednh l\u1eb7p<\/em><\/p>\n

B\u01b0\u1edbc 5: <\/strong>\u1ede m\u1ee5c Maximum Iterations<\/strong>, nh\u1eadp s\u1ed1 l\u1ea7n l\u1eb7p t\u1ed1i \u0111a m\u00e0 b\u1ea1n mu\u1ed1n Excel th\u1ef1c hi\u1ec7n, sau \u0111\u00f3 nh\u1ea5n OK<\/strong> \u0111\u1ec3 l\u01b0u thay \u0111\u1ed5i.<\/p>\n

\"T\u00f9y\u1ede m\u1ee5c Maximum Iterations, nh\u1eadp s\u1ed1 l\u1ea7n l\u1eb7p t\u1ed1i \u0111a m\u00e0 b\u1ea1n mu\u1ed1n<\/em><\/p>\n

L\u01b0u \u00fd: <\/strong>Vi\u1ec7c b\u1eadt t\u00ednh n\u0103ng n\u00e0y gi\u00fap Excel th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n theo chu k\u1ef3, nh\u01b0ng n\u1ebfu \u0111\u1eb7t s\u1ed1 v\u00f2ng l\u1eb7p qu\u00e1 cao, file c\u00f3 th\u1ec3 x\u1eed l\u00fd ch\u1eadm ho\u1eb7c sai l\u1ec7ch k\u1ebft qu\u1ea3. V\u00ec v\u1eady, b\u1ea1n n\u00ean x\u00e1c \u0111\u1ecbnh r\u00f5 m\u1ee5c \u0111\u00edch v\u00e0 gi\u1edbi h\u1ea1n l\u1eb7p ph\u00f9 h\u1ee3p tr\u01b0\u1edbc khi \u00e1p d\u1ee5ng.<\/p>\n

Hi\u1ec3u r\u00f5 l\u1ed7i Circular Reference gi\u00fap b\u1ea1n ch\u1ee7 \u0111\u1ed9ng x\u1eed l\u00fd v\u00e0 tr\u00e1nh nh\u1eefng sai s\u00f3t trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n tr\u00ean Excel. H\u00e3y lu\u00f4n ki\u1ec3m tra k\u1ef9 c\u00f4ng th\u1ee9c, gi\u1edbi h\u1ea1n v\u00f2ng l\u1eb7p h\u1ee3p l\u00fd khi c\u1ea7n s\u1eed d\u1ee5ng t\u00ednh to\u00e1n l\u1eb7p. V\u1edbi nh\u1eefng b\u01b0\u1edbc h\u01b0\u1edbng d\u1eabn tr\u00ean, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 l\u00e0m ch\u1ee7 Excel v\u00e0 n\u00e2ng cao hi\u1ec7u qu\u1ea3 l\u00e0m vi\u1ec7c h\u00e0ng ng\u00e0y.<\/p>\n

\u0110\u1eebng qu\u00ean theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 bi\u1ebft th\u00eam nhi\u1ec1u th\u00f4ng tin v\u00e0 m\u1eb9o hay h\u1eefu \u00edch.<\/p>\n

>> N\u1ebfu b\u1ea1n \u0111ang t\u00ecm thi\u1ebft b\u1ecb h\u1ed7 tr\u1ee3 h\u1ecdc t\u1eadp v\u00e0 l\u00e0m vi\u1ec7c tr\u00ean Excel ti\u1ec7n l\u1ee3i h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c d\u00f2ng m\u00e1y t\u00ednh b\u1ea3ng t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 t\u1ed1i \u01b0u hi\u1ec7u su\u1ea5t m\u1ed7i ng\u00e0y.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\u00a0 L\u1ed7i Circular Reference trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng l\u1ed7i ph\u1ed5 bi\u1ebfn khi\u1ebfn ng\u01b0\u1eddi d\u00f9ng g\u1eb7p kh\u00f3 kh\u0103n khi t\u00ednh to\u00e1n d\u1eef li\u1ec7u. Khi c\u00f4ng th\u1ee9c t\u1ef1 tham chi\u1ebfu \u0111\u1ebfn ch\u00ednh \u00f4 ch\u1ee9a n\u00f3, Excel s\u1ebd kh\u00f4ng th\u1ec3 x\u1eed l\u00fd v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 sai ho\u1eb7c b\u1eb1ng 0. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd […]<\/p>\n","protected":false},"author":1,"featured_media":4836,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4835","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19343.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4835","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=4835"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4835\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4836"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4835"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4835"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4835"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}