{"id":1103,"date":"2024-12-02T04:09:35","date_gmt":"2024-12-02T04:09:35","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-sua-loi-circular-references-warning-trong-excel-2010-2013-2016\/"},"modified":"2024-12-02T04:09:35","modified_gmt":"2024-12-02T04:09:35","slug":"huong-dan-cach-sua-loi-circular-references-warning-trong-excel-2010-2013-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-sua-loi-circular-references-warning-trong-excel-2010-2013-2016\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eeda l\u1ed7i Circular References Warning trong Excel 2010, 2013, 2016"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Trong b\u00e0i vi\u1ebft n\u00e0y ch\u00fang ta s\u1ebd c\u00f9ng t\u00ecm hi\u1ec3u v\u1ec1 l\u1ed7i\u00a0Circular References Warning trong Excel. L\u1ed7i n\u00e0y l\u00e0 l\u1ed7i g\u00ec, t\u1ea1i sao l\u1ea1i c\u00f3 l\u1ed7i n\u00e0y, c\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y nh\u01b0 th\u1ebf n\u00e0o?\u00a0B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn chi ti\u1ebft cho b\u1ea1n. Trong c\u00e1c phi\u00eam b\u1ea3n\u00a0Excel 2010, 2013, 2016\u00a0\u0111\u1ec1u gi\u1ed1ng nhau:<\/em><\/p>\n<figure id=\"attachment_12926\" aria-describedby=\"caption-attachment-12926\" style=\"width: 1320px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12926 size-full\" title=\"1 - s\u1eeda l\u1ed7i Circular References Warning trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic01-9.png\" alt=\"1 - s\u1eeda l\u1ed7i Circular References Warning trong Excel\" width=\"1320\" height=\"210\"><figcaption id=\"caption-attachment-12926\" class=\"wp-caption-text\">1 \u2013 s\u1eeda l\u1ed7i Circular References Warning trong Excel<\/figcaption><\/figure>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674d32ff0e850\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-sua-loi-circular-references-warning-trong-excel-2010-2013-2016.html#1_Y_nghia_cua_loi_Circular_References_Warning\" title=\"1.\u00a0\u00dd ngh\u0129a c\u1ee7a l\u1ed7i\u00a0Circular References Warning\">1.\u00a0\u00dd ngh\u0129a c\u1ee7a l\u1ed7i\u00a0Circular References Warning<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-sua-loi-circular-references-warning-trong-excel-2010-2013-2016.html#2_Cach_sua_loi_Circular_References_Warning\" title=\"2. C\u00e1ch s\u1eeda l\u1ed7i\u00a0Circular References Warning\">2. C\u00e1ch s\u1eeda l\u1ed7i\u00a0Circular References Warning<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-sua-loi-circular-references-warning-trong-excel-2010-2013-2016.html#Truong_hop_1_Loai_bo_vong_lap_do_vo_y\" title=\"Tr\u01b0\u1eddng h\u1ee3p 1: Lo\u1ea1i b\u1ecf v\u00f2ng l\u1eb7p (do v\u00f4 \u00fd)\">Tr\u01b0\u1eddng h\u1ee3p 1: Lo\u1ea1i b\u1ecf v\u00f2ng l\u1eb7p (do v\u00f4 \u00fd)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-sua-loi-circular-references-warning-trong-excel-2010-2013-2016.html#Truong_hop_2_Cho_phep_su_dung_vong_lap_co_y\" title=\"Tr\u01b0\u1eddng h\u1ee3p\u00a02. Cho ph\u00e9p s\u1eed d\u1ee5ng v\u00f2ng l\u1eb7p (c\u1ed1 \u00fd)\">Tr\u01b0\u1eddng h\u1ee3p\u00a02. Cho ph\u00e9p s\u1eed d\u1ee5ng v\u00f2ng l\u1eb7p (c\u1ed1 \u00fd)<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"1_Y_nghia_cua_loi_Circular_References_Warning\"><\/span>1.\u00a0\u00dd ngh\u0129a c\u1ee7a l\u1ed7i\u00a0Circular References Warning<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u00e2y kh\u00f4ng h\u1eb3n l\u00e0 1 l\u1ed7i, m\u00e0 n\u00f3 l\u00e0 1 th\u00f4ng b\u00e1o, c\u1ea3nh b\u00e1o (bi\u1ec3u t\u01b0\u1ee3ng h\u00ecnh tam gi\u00e1c m\u00e0u v\u00e0ng, b\u00ean trong c\u00f3 d\u1ea5u ch\u1ea5m than). N\u1ed9i dung c\u1ee7a th\u00f4ng b\u00e1o n\u00e0y l\u00e0: C\u00f3 1 v\u00f2ng l\u1eb7p trong\u00a0c\u00f4ng th\u1ee9c t\u00ednh.<\/p>\n<p>V\u00f2ng l\u1eb7p trong t\u00ednh to\u00e1n s\u1ebd khi\u1ebfn\u00a0Excel ti\u00eau t\u1ed1n b\u1ed9 nh\u1edb, t\u00e0i nguy\u00ean khi ph\u1ea3i th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh li\u00ean t\u1ee5c theo v\u00f2ng. B\u1edfi v\u1eady s\u1ebd lu\u00f4n c\u00f3 th\u00f4ng b\u00e1o cho ng\u01b0\u1eddi d\u00f9ng bi\u1ebft khi c\u00f3 v\u00f2ng l\u1eb7p trong b\u1ea3ng t\u00ednh\u00a0\u0111\u1ec3 c\u1ea3nh b\u00e1o ng\u01b0\u1eddi d\u00f9ng.<\/p>\n<p>Tuy nhi\u00ean kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o v\u00f2ng l\u1eb7p c\u0169ng l\u00e0 x\u1ea5u. Trong 1 s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, 1 s\u1ed1 thu\u1eadt to\u00e1n b\u1eaft bu\u1ed9c ph\u1ea3i xu\u1ea5t hi\u1ec7n v\u00f2ng l\u1eb7p. V\u00ec v\u1eady t\u00f9y t\u1eebng tr\u01b0\u1eddng h\u1ee3p s\u1ebd c\u00f3 c\u00e1ch x\u1eed l\u00fd kh\u00e1c nhau.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_Cach_sua_loi_Circular_References_Warning\"><\/span>2. C\u00e1ch s\u1eeda l\u1ed7i\u00a0Circular References Warning<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Th\u01b0\u1eddng vi\u1ec7c t\u00ednh to\u00e1n b\u1ecb v\u00f2ng l\u1eb7p c\u00f3 2 nguy\u00ean nh\u00e2n ch\u00ednh:<\/p>\n<ul>\n<li>Nguy\u00ean nh\u00e2n do c\u1ed1\u00a0\u00fd v\u00e0 mu\u1ed1n t\u00ednh to\u00e1n theo v\u00f2ng l\u1eb7p: B\u1ea1n bi\u1ebft r\u00f5 r\u1eb1ng s\u1ebd xu\u1ea5t hi\u1ec7n v\u00f2ng l\u1eb7p v\u00e0 ch\u1ea5p nh\u1eadn \u0111i\u1ec1u \u0111\u00f3 \u0111\u1ec3\u00a0khai th\u00e1c t\u00ednh n\u0103ng n\u00e0y.<\/li>\n<li>Nguy\u00ean nh\u00e2n do v\u00f4\u00a0\u00fd: b\u1ea1n kh\u00f4ng mu\u1ed1n ho\u1eb7c kh\u00f4ng bi\u1ebft r\u1eb1ng\u00a0\u0111\u00e3 t\u1ea1o ra v\u00f2ng l\u1eb7p, c\u1ea7n x\u1eed l\u00fd\u00a0\u0111\u1ec3 lo\u1ea1i b\u1ecf v\u00f2ng l\u1eb7p.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Truong_hop_1_Loai_bo_vong_lap_do_vo_y\"><\/span><strong><em>Tr\u01b0\u1eddng h\u1ee3p 1: Lo\u1ea1i b\u1ecf v\u00f2ng l\u1eb7p (do v\u00f4 \u00fd)<\/em><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>B\u1ecf\u00a0\u0111\u00e1nh d\u1ea5u ch\u1ecdn\u00a0\u1edf m\u1ee5c\u00a0<strong><em>Enable iterative calculation<\/em><\/strong>\u00a0(trong tr\u01b0\u1eddng h\u1ee3p 2 b\u00ean d\u01b0\u1edbi) \u0111\u1ec3 kh\u00f4ng t\u00ednh to\u00e1n theo v\u00f2ng l\u1eb7p.<\/li>\n<li>D\u1ef1a theo v\u1ecb tr\u00ed m\u00e0 ch\u1ee9c n\u0103ng\u00a0Error checking &gt; Circular References ch\u1ec9 d\u1eabn\u00a0\u0111\u1ec3 ki\u1ec3m tra l\u1ea1i c\u00f4ng th\u1ee9c, lo\u1ea1i b\u1ecf c\u00e1c tham chi\u1ebfu g\u00e2y l\u1eb7p trong c\u00f4ng th\u1ee9c\u00a0\u0111\u00f3 (x\u00f3a, chuy\u1ec3n c\u00f4ng th\u1ee9c th\u00e0nh ghi ch\u00fa ho\u1eb7c s\u1eeda l\u1ea1i tham chi\u1ebfu trong c\u00f4ng th\u1ee9c)<\/li>\n<\/ul>\n<figure id=\"attachment_12929\" aria-describedby=\"caption-attachment-12929\" style=\"width: 1172px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12929 size-full\" title=\"2 - s\u1eeda l\u1ed7i Circular References Warning trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic03-7.png\" alt=\"2 - s\u1eeda l\u1ed7i Circular References Warning trong Excel\" width=\"1172\" height=\"248\"><figcaption id=\"caption-attachment-12929\" class=\"wp-caption-text\">2 \u2013 s\u1eeda l\u1ed7i Circular References Warning trong Excel<\/figcaption><\/figure>\n<p>Nh\u01b0 v\u1eady l\u00e0 ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 y\u00ean t\u00e2m x\u1eed l\u00fd khi g\u1eb7p l\u1ed7i\u00a0Circular References Warning trong Excel 2010, 2013, 2016 r\u1ed3i.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Truong_hop_2_Cho_phep_su_dung_vong_lap_co_y\"><\/span>Tr\u01b0\u1eddng h\u1ee3p\u00a02. Cho ph\u00e9p s\u1eed d\u1ee5ng v\u00f2ng l\u1eb7p (c\u1ed1 \u00fd)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Th\u01b0\u1eddng ch\u1ec9 \u00e1p d\u1ee5ng cho m\u1ed9t s\u1ed1 t\u00ednh n\u0103ng nh\u1ea5t \u0111\u1ecbnh, v\u00ed d\u1ee5: B\u1ea1n l\u1eadp s\u1eb5n c\u1ed9t d\u1eef li\u1ec7u ghi nh\u1eadn th\u1eddi gian NOW() khi g\u00f5 d\u1eef li\u1ec7u v\u00e0o m\u1ed9t \u00f4 nh\u1ea5t \u0111\u1ecbnh, th\u00ec c\u1ed9t b\u00ean c\u1ea1nh ghi nh\u1eadn th\u1eddi gian nh\u1eadp. V\u00e0 sau \u0111\u00f3, th\u00ec th\u1eddi gian s\u1ebd kh\u00f4ng c\u1eadp nh\u1eadt n\u1eefa, m\u1eb7c d\u00f9 ch\u00fang ta d\u00f9ng h\u00e0m NOW(). L\u00fac n\u00e0y, ta s\u1ebd \u00e1p d\u1ee5ng t\u00ednh n\u0103ng n\u00e0y. V\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-77.gif\" title=\"ex101_92019-nho-77\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure id=\"attachment_24430\" aria-describedby=\"caption-attachment-24430\" style=\"width: 671px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/05\/circular-reference-time.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-24430 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/circular-reference-time.jpg\" alt=\"3 - s\u1eeda l\u1ed7i Circular References Warning trong Excel\" width=\"671\" height=\"246\" title=\"circular-reference-time\"><\/a><figcaption id=\"caption-attachment-24430\" class=\"wp-caption-text\">3 \u2013 s\u1eeda l\u1ed7i Circular References Warning trong Excel<\/figcaption><\/figure>\n<p>Thi\u1ebft l\u1eadp cho ph\u00e9p s\u1eed d\u1ee5ng v\u00f2ng l\u1eb7p khi t\u00ednh to\u00e1n trong th\u1ebb File \/ Option \/ Formulas r\u1ed3i\u00a0\u0111\u00e1nh d\u1ea5u v\u00e0o m\u1ee5c\u00a0\u00a0<strong>Enable iterative calculation<\/strong>\u00a0(Cho ph\u00e9p t\u00ednh to\u00e1n l\u1eb7p).<\/p>\n<figure id=\"attachment_12930\" aria-describedby=\"caption-attachment-12930\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12930 size-large\" title=\"4 - s\u1eeda l\u1ed7i Circular References Warning trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic04-7-1024x844-1.png\" alt=\"4 - s\u1eeda l\u1ed7i Circular References Warning trong Excel\" width=\"1024\" height=\"844\"><figcaption id=\"caption-attachment-12930\" class=\"wp-caption-text\">4 \u2013 s\u1eeda l\u1ed7i Circular References Warning trong Excel<\/figcaption><\/figure>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n \u201c<strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong>\u201c.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0\u0111\u00e1p\u00a0\u1ee9ng y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c t\u1ed5 ch\u1ee9c, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u v\u00e0 l\u1eadp b\u00e1o c\u00e1o tr\u00ean\u00a0Excel.<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-77.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1104,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1103","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\/1103","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=1103"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1103\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1104"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}