Giúp đỡ file excel quá chậm và nặng (1 người xem)

[Boom Thắng]

Xin chào các anh chị, bạn bè trên diễn đàn.
Mình đang làm việc với 1 file excel như file đính kèm. Hiện tại mỗi lần thao tác với file phải chờ đợi rất lâu.
Mình có tham khảo và thực hiện theo một số hướng dẫn trên diễn đàn để giúp file nhẹ hơn, nhưng hiệu quả không được như mong đợi.
Rất mong mọi người có thể tìm giúp nguyên nhân và hướng dẫn mình khắc phục.
Xin cảm ơn ạ!

 

[vu_tuan_manh_linh]

Dòng thừa cột thừa quá nhiều, bạn xóa đi là được.
Công thức lỗi cũng là 1 nguyên nhân.

 

[Boom Thắng]

Dòng thừa cột thừa quá nhiều, bạn xóa đi là được.
Công thức lỗi cũng là 1 nguyên nhân.

Cảm ơn bạn, mình đã thử nhưng chưa có sự cải thiện lắm ạ.

 

[AnhThu-1976]

Cảm ơn bạn, mình đã thử nhưng chưa có sự cải thiện lắm ạ.

Xem Conditional Formatting xem, mới 1 cái ở sheet Data

[TABLE]
[TR]
[TD]=$H$16:$BR$16;$H$30:$BR$30;$H$44:$BR$44;$H$58:$BR$58;$H$74:$BR$74;$H$88:$BR$88;$H$102:$BR$102;$H$116:$BR$116;$H$130:$BR$130;$H$144:$BR$144;$H$158:$BR$158;$H$178:$BR$178;$H$192:$BR$192;$H$212:$BR$212;$H$226:$BR$226;$H$246:$BR$246;$H$260:$BR$260;$H$274:$BR$274;$H$288:$BR$288;$H$302:$BR$302;$H$316:$BR$316;$H$330:$BR$330;$H$344:$BR$344;$H$358:$BR$358;$H$372:$BR$372;$H$386:$BR$386;$H$400:$BR$400;$H$414:$BR$414;$H$428:$BR$428;$H$442:$BR$442;$H$456:$BR$456;$H$470:$BR$470;$H$484:$BR$484;$H$498:$BR$498;$H$512:$BR$512;$H$526:$BR$526;$H$540:$BR$540;$H$554:$BR$554;$H$568:$BR$568;$H$582:$BR$582;$H$596:$BR$596;$H$616:$BR$616;$H$630:$BR$630;$H$644:$BR$644;$H$658:$BR$658;$H$686:$BR$686;$H$706:$BR$706;$H$740:$BR$740;$H$754:$BR$754;$H$768:$BR$768;$H$782:$BR$782;$H$796:$BR$796;$H$810:$BR$810;$H$824:$BR$824;$H$838:$BR$838;$H$852:$BR$852;$H$866:$BR$866;$H$880:$BR$880;$H$894:$BR$894;$H$908:$BR$908;$H$922:$BR$922;$H$936:$BR$936;$H$950:$BR$950;$H$964:$BR$964;$H$978:$BR$978;$H$992:$BR$992;$H$1006:$BR$1006;$H$1020:$BR$1020;$H$1034:$BR$1034;$H$1048:$BR$1048;$H$1062:$BR$1062;$H$1076:$BR$1076;$H$1090:$BR$1090;$H$1104:$BR$1104;$H$1118:$BR$1118;$H$1138:$BR$1138;$H$1152:$BR$1152;$H$1166:$BR$1166;$H$1180:$BR$1180;$H$1194:$BR$1194;$H$1208:$BR$1208;$H$1222:$BR$1222;$H$1236:$BR$1236;$H$1250:$BR$1250;$H$1264:$BR$1264;$H$1278:$BR$1278;$H$1292:$BR$1292;$H$1306:$BR$1306;$H$1320:$BR$1320;$H$1334:$BR$1334;$H$1348:$BR$1348;$H$1362:$BR$1362;$H$1376:$BR$1376;$H$1396:$BR$1396;$H$1410:$BR$1410;$H$1424:$BR$1424;$H$1438:$BR$1438;$H$1452:$BR$1452;$H$1466:$BR$1466;$H$1480:$BR$1480;$H$1494:$BR$1494;$H$1508:$BR$1508;$H$1522:$BR$1522;$H$1536:$BR$1536;$H$1550:$BR$1550;$H$1564:$BR$1564;$H$1578:$BR$1578;$H$1592:$BR$1592;$H$1606:$BR$1606;$H$1620:$BR$1620;$H$1634:$BR$1634;$H$1648:$BR$1648;$H$1674:$BR$1674;$H$1792:$BR$1792;$H$1806:$BR$1806;$H$1832:$BR$1832;$H$2030:$BR$2030;$H$672:$BR$672;$CT$672;$CT$2030;$CT$1832;$CT$1806;$CT$1792;$CT$1674;$CT$1648;$CT$1634;$CT$1620;$CT$1606;$CT$1592;$CT$1578;$CT$1564;$CT$1550;$CT$1536;$CT$1522;$CT$1508;$CT$1494;$CT$1480;$CT$1466;$CT$1452;$CT$1438;$CT$1424;$CT$1410;$CT$1396;$CT$1376;$CT$1362;$CT$1348;$CT$1334;$CT$1320;$CT$1306;$CT$1292;$CT$1278;$CT$1264;$CT$1250;$CT$1236;$CT$1222;$CT$1208;$CT$1194;$CT$1180;$CT$1166;$CT$1152;$CT$1138;$CT$1118;$CT$1104;$CT$1090;$CT$1076;$CT$1062;$CT$1048;$CT$1034;$CT$1020;$CT$1006;$CT$992;$CT$978;$CT$964;$CT$950;$CT$936;$CT$922;$CT$908;$CT$894;$CT$880;$CT$866;$CT$852;$CT$838;$CT$824;$CT$810;$CT$796;$CT$782;$CT$768;$CT$754;$CT$740;$CT$706;$CT$686;$CT$658;$CT$644;$CT$630;$CT$616;$CT$596;$CT$582;$CT$568;$CT$554;$CT$540;$CT$526;$CT$512;$CT$498;$CT$484;$CT$470;$CT$456;$CT$442;$CT$428;$CT$414;$CT$400;$CT$386;$CT$372;$CT$358;$CT$344;$CT$330;$CT$316;$CT$302;$CT$288;$CT$274;$CT$260;$CT$246;$CT$226;$CT$212;$CT$192;$CT$178;$CT$158;$CT$144;$CT$130;$CT$116;$CT$102;$CT$88;$CT$74;$CT$58;$CT$44;$CT$30;$CT$16;$CP$672:$CQ$672;$CP$2030:$CQ$2030;$CP$1832:$CQ$1832;$CP$1806:$CQ$1806;$CP$1792:$CQ$1792;$CP$1674:$CQ$1674;$CP$1648:$CQ$1648;$CP$1634:$CQ$1634;$CP$1620:$CQ$1620;$CP$1606:$CQ$1606;$CP$1592:$CQ$1592;$CP$1578:$CQ$1578;$CP$1564:$CQ$1564;$CP$1550:$CQ$1550;$CP$1536:$CQ$1536;$CP$1522:$CQ$1522;$CP$1508:$CQ$1508;$CP$1494:$CQ$1494;$CP$1480:$CQ$1480;$CP$1466:$CQ$1466;$CP$1452:$CQ$1452;$CP$1438:$CQ$1438;$CP$1424:$CQ$1424;$CP$1410:$CQ$1410;$CP$1396:$CQ$1396;$CP$1376:$CQ$1376;$CP$1362:$CQ$1362;$CP$1348:$CQ$1348;$CP$1334:$CQ$1334;$CP$1320:$CQ$1320;$CP$1306:$CQ$1306;$CP$1292:$CQ$1292;$CP$1278:$CQ$1278;$CP$1264:$CQ$1264;$CP$1250:$CQ$1250;$CP$1236:$CQ$1236;$CP$1222:$CQ$1222;$CP$1208:$CQ$1208;$CP$1194:$CQ$1194;$CP$1180:$CQ$1180;$CP$1166:$CQ$1166;$CP$1152:$CQ$1152;$CP$1138:$CQ$1138;$CP$1118:$CQ$1118;$CP$1104:$CQ$1104;$CP$1090:$CQ$1090;$CP$1076:$CQ$1076;$CP$1062:$CQ$1062;$CP$1048:$CQ$1048;$CP$1034:$CQ$1034;$CP$1020:$CQ$1020;$CP$1006:$CQ$1006;$CP$992:$CQ$992;$CP$978:$CQ$978;$CP$964:$CQ$964;$CP$950:$CQ$950;$CP$936:$CQ$936;$CP$922:$CQ$922;$CP$908:$CQ$908;$CP$894:$CQ$894;$CP$880:$CQ$880;$CP$866:$CQ$866;$CP$852:$CQ$852;$CP$838:$CQ$838;$CP$824:$CQ$824;$CP$810:$CQ$810;$CP$796:$CQ$796;$CP$782:$CQ$782;$CP$768:$CQ$768;$CP$754:$CQ$754;$CP$740:$CQ$740;$CP$706:$CQ$706;$CP$686:$CQ$686;$CP$658:$CQ$658;$CP$644:$CQ$644;$CP$630:$CQ$630;$CP$616:$CQ$616;$CP$596:$CQ$596;$CP$582:$CQ$582;$CP$568:$CQ$568;$CP$554:$CQ$554;$CP$540:$CQ$540;$CP$526:$CQ$526;$CP$512:$CQ$512;$CP$498:$CQ$498;$CP$484:$CQ$484;$CP$470:$CQ$470;$CP$456:$CQ$456;$CP$442:$CQ$442;$CP$428:$CQ$428;$CP$414:$CQ$414;$CP$400:$CQ$400;$CP$386:$CQ$386;$CP$372:$CQ$372;$CP$358:$CQ$358;$CP$344:$CQ$344;$CP$330:$CQ$330;$CP$316:$CQ$316;$CP$302:$CQ$302;$CP$288:$CQ$288;$CP$274:$CQ$274;$CP$260:$CQ$260;$CP$246:$CQ$246;$CP$226:$CQ$226;$CP$212:$CQ$212;$CP$192:$CQ$192;$CP$178:$CQ$178;$CP$158:$CQ$158;$CP$144:$CQ$144;$CP$130:$CQ$130;$CP$116:$CQ$116;$CP$102:$CQ$102;$CP$88:$CQ$88;$CP$74:$CQ$74;$CP$58:$CQ$58;$CP$44:$CQ$44;$CP$30:$CQ$30;$CP$16:$CQ$16;$CV$16;$CV$30;$CV$44;$CV$58;$CV$74;$CV$88;$CV$102;$CV$116;$CV$130;$CV$144;$CV$158;$CV$178;$CV$192;$CV$212;$CV$226;$CV$246;$CV$260;$CV$274;$CV$288;$CV$302;$CV$316;$CV$330;$CV$344;$CV$358;$CV$372;$CV$386;$CV$400;$CV$414;$CV$428;$CV$442;$CV$456;$CV$470;$CV$484;$CV$498;$CV$512;$CV$526;$CV$540;$CV$554;$CV$568;$CV$582;$CV$596;$CV$616;$CV$630;$CV$644;$CV$658;$CV$686;$CV$706;$CV$740;$CV$754;$CV$768;$CV$782;$CV$796;$CV$810;$CV$824;$CV$838;$CV$852;$CV$866;$CV$880;$CV$894;$CV$908;$CV$922;$CV$936;$CV$950;$CV$964;$CV$978;$CV$992;$CV$1006;$CV$1020;$CV$1034;$CV$1048;$CV$1062;$CV$1076;$CV$1090;$CV$1104;$CV$1118;$CV$1138;$CV$1152;$CV$1166;$CV$1180;$CV$1194;$CV$1208;$CV$1222;$CV$1236;$CV$1250;$CV$1264;$CV$1278;$CV$1292;$CV$1306;$CV$1320;$CV$1334;$CV$1348;$CV$1362;$CV$1376;$CV$1396;$CV$1410;$CV$1424;$CV$1438;$CV$1452;$CV$1466;$CV$1480;$CV$1494;$CV$1508;$CV$1522;$CV$1536;$CV$1550;$CV$1564;$CV$1578;$CV$1592;$CV$1606;$CV$1620;$CV$1634;$CV$1648;$CV$1674;$CV$1792;$CV$1806;$CV$1832;$CV$2030;$CV$672;$CL$672:$CN$672;$CL$2030:$CN$2030;$CL$1832:$CN$1832;$CL$1806:$CN$1806;$CL$1792:$CN$1792;$CL$1674:$CN$1674;$CL$1648:$CN$1648;$CL$1634:$CN$1634;$CL$1620:$CN$1620;$CL$1606:$CN$1606;$CL$1592:$CN$1592;$CL$1578:$CN$1578;$CL$1564:$CN$1564;$CL$1550:$CN$1550;$CL$1536:$CN$1536;$CL$1522:$CN$1522;$CL$1508:$CN$1508;$CL$1494:$CN$1494;$CL$1480:$CN$1480;$CL$1466:$CN$1466;$CL$1452:$CN$1452;$CL$1438:$CN$1438;$CL$1424:$CN$1424;$CL$1410:$CN$1410;$CL$1396:$CN$1396;$CL$1376:$CN$1376;$CL$1362:$CN$1362;$CL$1348:$CN$1348;$CL$1334:$CN$1334;$CL$1320:$CN$1320;$CL$1306:$CN$1306;$CL$1292:$CN$1292;$CL$1278:$CN$1278;$CL$1264:$CN$1264;$CL$1250:$CN$1250;$CL$1236:$CN$1236;$CL$1222:$CN$1222;$CL$1208:$CN$1208;$CL$1194:$CN$1194;$CL$1180:$CN$1180;$CL$1166:$CN$1166;$CL$1152:$CN$1152;$CL$1138:$CN$1138;$CL$1118:$CN$1118;$CL$1104:$CN$1104;$CL$1090:$CN$1090;$CL$1076:$CN$1076;$CL$1062:$CN$1062;$CL$1048:$CN$1048;$CL$1034:$CN$1034;$CL$1020:$CN$1020;$CL$1006:$CN$1006;$CL$992:$CN$992;$CL$978:$CN$978;$CL$964:$CN$964;$CL$950:$CN$950;$CL$936:$CN$936;$CL$922:$CN$922;$CL$908:$CN$908;$CL$894:$CN$894;$CL$880:$CN$880;$CL$866:$CN$866;$CL$852:$CN$852;$CL$838:$CN$838;$CL$824:$CN$824;$CL$810:$CN$810;$CL$796:$CN$796;$CL$782:$CN$782;$CL$768:$CN$768;$CL$754:$CN$754;$CL$740:$CN$740;$CL$706:$CN$706;$CL$686:$CN$686;$CL$658:$CN$658;$CL$644:$CN$644;$CL$630:$CN$630;$CL$616:$CN$616;$CL$596:$CN$596;$CL$582:$CN$582;$CL$568:$CN$568;$CL$554:$CN$554;$CL$540:$CN$540;$CL$526:$CN$526;$CL$512:$CN$512;$CL$498:$CN$498;$CL$484:$CN$484;$CL$470:$CN$470;$CL$456:$CN$456;$CL$442:$CN$442;$CL$428:$CN$428;$CL$414:$CN$414;$CL$400:$CN$400;$CL$386:$CN$386;$CL$372:$CN$372;$CL$358:$CN$358;$CL$344:$CN$344;$CL$330:$CN$330;$CL$316:$CN$316;$CL$302:$CN$302;$CL$288:$CN$288;$CL$274:$CN$274;$CL$260:$CN$260;$CL$246:$CN$246;$CL$226:$CN$226;$CL$212:$CN$212;$CL$192:$CN$192;$CL$178:$CN$178;$CL$158:$CN$158;$CL$144:$CN$144;$CL$130:$CN$130;$CL$116:$CN$116;$CL$102:$CN$102;$CL$88:$CN$88;$CL$74:$CN$74;$CL$58:$CN$58;$CL$44:$CN$44;$CL$30:$CN$30;$CL$16:$CN$16;$CJ$672;$CJ$2030;$CJ$1832;$CJ$1806;$CJ$1792;$CJ$1674;$CJ$1648;$CJ$1634;$CJ$1620;$CJ$1606;$CJ$1592;$CJ$1578;$CJ$1564;$CJ$1550;$CJ$1536;$CJ$1522;$CJ$1508;$CJ$1494;$CJ$1480;$CJ$1466;$CJ$1452;$CJ$1438;$CJ$1424;$CJ$1410;$CJ$1396;$CJ$1376;$CJ$1362;$CJ$1348;$CJ$1334;$CJ$1320;$CJ$1306;$CJ$1292;$CJ$1278;$CJ$1264;$CJ$1250;$CJ$1236;$CJ$1222;$CJ$1208;$CJ$1194;$CJ$1180;$CJ$1166;$CJ$1152;$CJ$1138;$CJ$1118

[/TD]
[/TR]
[/TABLE]