Re: [belajar-excel] Excel lemot ?

rullp return [email protected] [belajar-excel] Thu, 21 Jan 2016 04:15:52 -0800


--------------------------------------------
Pada Kam, 21/1/16, 'Mr. Kid' [email protected] [belajar-excel] 
<[email protected]> menulis:




 Judul: Re: [belajar-excel] Excel lemot ?
 Kepada: "BeExcel" <[email protected]>
 Tanggal: Kamis, 21 Januari, 2016, 5:14 PM


  

 Terima kasih,
akan saya coba cek ulang, tapi ini terjadi secara tiba2...
mohon maaf karena saya masih awam






       Hai,

 Biasanya Excel akan
 terasa lemot dengan segera karena hal berikut :

 1. Formula yang berisi fungsi-fungsi
 volatile seperti (Now, Today, Rand, RandBetween, Offset,
 Indirect) dibanyak cells
     >
 coba periksa ulang formula yang ada, dan hindari penggunaan
 fungsi tersebut dibanyak cells.
 2.
 Conditional Formatting yang sangat banyak
     > coba periksa ulang
 Conditional Formatting di setiap sheet dan kalau bisa di
 setiap cells. Pastikan tidak ada Conditional Formatting
 dengan rules yang sama tetapi apply range nya
 berbeda-beda.
     > Contoh :
 kolom X berisi 15000 baris sebenarnya hanya membutuhkan 1
 rules conditional formatting yang bisa dipakai oleh 15000
 baris.
                      
 tetapi, dikolom X ada lebih dari 1 conditional formatting
 dengan bunyi rules yang sama, dan hanya berbeda di apply
 range nya
     > Jika menemukan
 Conditional Formatting seperti ini, sebaiknya conditional
 formatting di area tersebut ditata ulang.
    
 > Conditional Formatting akan selalu dieksekusi oleh
 Excel, sehingga CF yang tumpang tindih atau banyak rules
 yang sama hanya berbeda apply range akan menambah jumlah
 proses yang harus diselesaikan Excel.

 Regards,
 Kid






 2016-01-21 11:52 GMT+07:00
 rullp return [email protected]
 [belajar-excel] <[email protected]>:















  








     
       walnya saya bikin file ini, lancar tanpa hambatan
 tapi kenapa sekarang jadi lemot..., padahal tidak ada
 penambahan Macro ( VBA ) ataupun formula yang lainnya. mohon
 pencerahan nya SUHU...



 --- Mods ---

 File lampiran lebih dari 250KB dilepas dari email. Silakan
 penanya mengirim ulang file lampiran yang diusahakan
 maksimal 250KB yang berisi contoh data, dengan cara me-reply
 email ini.

 ----------------




  


























 #yiv2140220799 #yiv2140220799 --
   #yiv2140220799ygrp-mkp {
 border:1px solid #d8d8d8;font-family:Arial;margin:10px
 0;padding:0 10px;}

 #yiv2140220799 #yiv2140220799ygrp-mkp hr {
 border:1px solid #d8d8d8;}

 #yiv2140220799 #yiv2140220799ygrp-mkp #yiv2140220799hd {
 color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
 0;}

 #yiv2140220799 #yiv2140220799ygrp-mkp #yiv2140220799ads {
 margin-bottom:10px;}

 #yiv2140220799 #yiv2140220799ygrp-mkp .yiv2140220799ad {
 padding:0 0;}

 #yiv2140220799 #yiv2140220799ygrp-mkp .yiv2140220799ad p {
 margin:0;}

 #yiv2140220799 #yiv2140220799ygrp-mkp .yiv2140220799ad a {
 color:#0000ff;text-decoration:none;}
 #yiv2140220799 #yiv2140220799ygrp-sponsor
 #yiv2140220799ygrp-lc {
 font-family:Arial;}

 #yiv2140220799 #yiv2140220799ygrp-sponsor
 #yiv2140220799ygrp-lc #yiv2140220799hd {
 margin:10px
 0px;font-weight:700;font-size:78%;line-height:122%;}

 #yiv2140220799 #yiv2140220799ygrp-sponsor
 #yiv2140220799ygrp-lc .yiv2140220799ad {
 margin-bottom:10px;padding:0 0;}


 #yiv2140220799 #yiv2140220799actions {
 font-family:Verdana;font-size:11px;padding:10px 0;}

 #yiv2140220799 #yiv2140220799activity {
 
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}


 #yiv2140220799 #yiv2140220799activity span {
 font-weight:700;}

 #yiv2140220799 #yiv2140220799activity span:first-child {
 text-transform:uppercase;}

 #yiv2140220799 #yiv2140220799activity span a {
 color:#5085b6;text-decoration:none;}

 #yiv2140220799 #yiv2140220799activity span span {
 color:#ff7900;}

 #yiv2140220799 #yiv2140220799activity span
 .yiv2140220799underline {
 text-decoration:underline;}

 #yiv2140220799 .yiv2140220799attach {
 clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
 0;width:400px;}

 #yiv2140220799 .yiv2140220799attach div a {
 text-decoration:none;}

 #yiv2140220799 .yiv2140220799attach img {
 border:none;padding-right:5px;}

 #yiv2140220799 .yiv2140220799attach label {
 display:block;margin-bottom:5px;}

 #yiv2140220799 .yiv2140220799attach label a {

 text-decoration:none;}

 #yiv2140220799 blockquote {
 margin:0 0 0 4px;}


 #yiv2140220799 .yiv2140220799bold {
 font-family:Arial;font-size:13px;font-weight:700;}

 #yiv2140220799 .yiv2140220799bold a {
 text-decoration:none;}

 #yiv2140220799 dd.yiv2140220799last p a {
 font-family:Verdana;font-weight:700;}

 #yiv2140220799 dd.yiv2140220799last p span {
 margin-right:10px;font-family:Verdana;font-weight:700;}

 #yiv2140220799 dd.yiv2140220799last p
 span.yiv2140220799yshortcuts {
 margin-right:0;}

 #yiv2140220799 div.yiv2140220799attach-table div div a {
 text-decoration:none;}

 #yiv2140220799 div.yiv2140220799attach-table {
 width:400px;}

 #yiv2140220799 div.yiv2140220799file-title a, #yiv2140220799
 div.yiv2140220799file-title a:active, #yiv2140220799
 div.yiv2140220799file-title a:hover, #yiv2140220799
 div.yiv2140220799file-title a:visited {
 text-decoration:none;}

 #yiv2140220799 div.yiv2140220799photo-title a,
 #yiv2140220799 div.yiv2140220799photo-title a:active,
 #yiv2140220799 div.yiv2140220799photo-title a:hover,
 #yiv2140220799 div.yiv2140220799photo-title a:visited {
 text-decoration:none;}

 #yiv2140220799 div#yiv2140220799ygrp-mlmsg
 #yiv2140220799ygrp-msg p a span.yiv2140220799yshortcuts {
 font-family:Verdana;font-size:10px;font-weight:normal;}

 #yiv2140220799 .yiv2140220799green {
 color:#628c2a;}

 #yiv2140220799 .yiv2140220799MsoNormal {
 margin:0 0 0 0;}

 #yiv2140220799 o {
 font-size:0;}

 #yiv2140220799 #yiv2140220799photos div {
 float:left;width:72px;}

 #yiv2140220799 #yiv2140220799photos div div {
 border:1px solid
 #666666;height:62px;overflow:hidden;width:62px;}

 #yiv2140220799 #yiv2140220799photos div label {
 
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

 #yiv2140220799 #yiv2140220799reco-category {
 font-size:77%;}

 #yiv2140220799 #yiv2140220799reco-desc {
 font-size:77%;}

 #yiv2140220799 .yiv2140220799replbq {
 margin:4px;}

 #yiv2140220799 #yiv2140220799ygrp-actbar div a:first-child {
 margin-right:2px;padding-right:5px;}

 #yiv2140220799 #yiv2140220799ygrp-mlmsg {
 font-size:13px;font-family:Arial, helvetica, clean,
 sans-serif;}

 #yiv2140220799 #yiv2140220799ygrp-mlmsg table {
 font-size:inherit;font:100%;}

 #yiv2140220799 #yiv2140220799ygrp-mlmsg select,
 #yiv2140220799 input, #yiv2140220799 textarea {
 font:99% Arial, Helvetica, clean, sans-serif;}

 #yiv2140220799 #yiv2140220799ygrp-mlmsg pre, #yiv2140220799
 code {
 font:115% monospace;}

 #yiv2140220799 #yiv2140220799ygrp-mlmsg * {
 line-height:1.22em;}

 #yiv2140220799 #yiv2140220799ygrp-mlmsg #yiv2140220799logo {
 padding-bottom:10px;}


 #yiv2140220799 #yiv2140220799ygrp-msg p a {
 font-family:Verdana;}

 #yiv2140220799 #yiv2140220799ygrp-msg
 p#yiv2140220799attach-count span {
 color:#1E66AE;font-weight:700;}

 #yiv2140220799 #yiv2140220799ygrp-reco
 #yiv2140220799reco-head {
 color:#ff7900;font-weight:700;}

 #yiv2140220799 #yiv2140220799ygrp-reco {
 margin-bottom:20px;padding:0px;}

 #yiv2140220799 #yiv2140220799ygrp-sponsor #yiv2140220799ov
 li a {
 font-size:130%;text-decoration:none;}

 #yiv2140220799 #yiv2140220799ygrp-sponsor #yiv2140220799ov
 li {
 font-size:77%;list-style-type:square;padding:6px 0;}

 #yiv2140220799 #yiv2140220799ygrp-sponsor #yiv2140220799ov
 ul {
 margin:0;padding:0 0 0 8px;}

 #yiv2140220799 #yiv2140220799ygrp-text {
 font-family:Georgia;}

 #yiv2140220799 #yiv2140220799ygrp-text p {
 margin:0 0 1em 0;}

 #yiv2140220799 #yiv2140220799ygrp-text tt {
 font-size:120%;}

 #yiv2140220799 #yiv2140220799ygrp-vital ul li:last-child {
 border-right:none !important;
 }
 #yiv2140220799

Re: [belajar-excel] Excel lemot ?

Kirim email ke