untuk file yang sudah besar bisa di baca2 di backup milis, disini br,
odong nando
Pada Rabu, 2 Maret 2016 15:32, "Cito Akbar [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear Para Master Excel,
saya ada kendala dengan data saya yang lumayan sudah byk dan fileny sudah
besar,
kenapa untuk data dengan formula tidak bisa langsung update jika data dari
penulusuran sudah diganti, fungsi vlookup,
saya mesti pilih lagi secara manual untuk file penelusurannya tersebut.
apa yang harus saya lakukan agar data saya itu selalu update dengan data
penelusuran tersebut jika data dipenelusaran tersebut diupdate/diganti.
Thanks in advance.
regardscito akbar
#yiv8162875423 #yiv8162875423 -- #yiv8162875423ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8162875423
#yiv8162875423ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8162875423
#yiv8162875423ygrp-mkp #yiv8162875423hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8162875423 #yiv8162875423ygrp-mkp #yiv8162875423ads
{margin-bottom:10px;}#yiv8162875423 #yiv8162875423ygrp-mkp .yiv8162875423ad
{padding:0 0;}#yiv8162875423 #yiv8162875423ygrp-mkp .yiv8162875423ad p
{margin:0;}#yiv8162875423 #yiv8162875423ygrp-mkp .yiv8162875423ad a
{color:#0000ff;text-decoration:none;}#yiv8162875423 #yiv8162875423ygrp-sponsor
#yiv8162875423ygrp-lc {font-family:Arial;}#yiv8162875423
#yiv8162875423ygrp-sponsor #yiv8162875423ygrp-lc #yiv8162875423hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8162875423
#yiv8162875423ygrp-sponsor #yiv8162875423ygrp-lc .yiv8162875423ad
{margin-bottom:10px;padding:0 0;}#yiv8162875423 #yiv8162875423actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8162875423
#yiv8162875423activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8162875423
#yiv8162875423activity span {font-weight:700;}#yiv8162875423
#yiv8162875423activity span:first-child
{text-transform:uppercase;}#yiv8162875423 #yiv8162875423activity span a
{color:#5085b6;text-decoration:none;}#yiv8162875423 #yiv8162875423activity span
span {color:#ff7900;}#yiv8162875423 #yiv8162875423activity span
.yiv8162875423underline {text-decoration:underline;}#yiv8162875423
.yiv8162875423attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8162875423 .yiv8162875423attach div a
{text-decoration:none;}#yiv8162875423 .yiv8162875423attach img
{border:none;padding-right:5px;}#yiv8162875423 .yiv8162875423attach label
{display:block;margin-bottom:5px;}#yiv8162875423 .yiv8162875423attach label a
{text-decoration:none;}#yiv8162875423 blockquote {margin:0 0 0
4px;}#yiv8162875423 .yiv8162875423bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8162875423
.yiv8162875423bold a {text-decoration:none;}#yiv8162875423 dd.yiv8162875423last
p a {font-family:Verdana;font-weight:700;}#yiv8162875423 dd.yiv8162875423last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8162875423
dd.yiv8162875423last p span.yiv8162875423yshortcuts
{margin-right:0;}#yiv8162875423 div.yiv8162875423attach-table div div a
{text-decoration:none;}#yiv8162875423 div.yiv8162875423attach-table
{width:400px;}#yiv8162875423 div.yiv8162875423file-title a, #yiv8162875423
div.yiv8162875423file-title a:active, #yiv8162875423
div.yiv8162875423file-title a:hover, #yiv8162875423 div.yiv8162875423file-title
a:visited {text-decoration:none;}#yiv8162875423 div.yiv8162875423photo-title a,
#yiv8162875423 div.yiv8162875423photo-title a:active, #yiv8162875423
div.yiv8162875423photo-title a:hover, #yiv8162875423
div.yiv8162875423photo-title a:visited {text-decoration:none;}#yiv8162875423
div#yiv8162875423ygrp-mlmsg #yiv8162875423ygrp-msg p a
span.yiv8162875423yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8162875423
.yiv8162875423green {color:#628c2a;}#yiv8162875423 .yiv8162875423MsoNormal
{margin:0 0 0 0;}#yiv8162875423 o {font-size:0;}#yiv8162875423
#yiv8162875423photos div {float:left;width:72px;}#yiv8162875423
#yiv8162875423photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8162875423
#yiv8162875423photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8162875423
#yiv8162875423reco-category {font-size:77%;}#yiv8162875423
#yiv8162875423reco-desc {font-size:77%;}#yiv8162875423 .yiv8162875423replbq
{margin:4px;}#yiv8162875423 #yiv8162875423ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8162875423 #yiv8162875423ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8162875423
#yiv8162875423ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8162875423
#yiv8162875423ygrp-mlmsg select, #yiv8162875423 input, #yiv8162875423 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8162875423
#yiv8162875423ygrp-mlmsg pre, #yiv8162875423 code {font:115%
monospace;}#yiv8162875423 #yiv8162875423ygrp-mlmsg *
{line-height:1.22em;}#yiv8162875423 #yiv8162875423ygrp-mlmsg #yiv8162875423logo
{padding-bottom:10px;}#yiv8162875423 #yiv8162875423ygrp-msg p a
{font-family:Verdana;}#yiv8162875423 #yiv8162875423ygrp-msg
p#yiv8162875423attach-count span {color:#1E66AE;font-weight:700;}#yiv8162875423
#yiv8162875423ygrp-reco #yiv8162875423reco-head
{color:#ff7900;font-weight:700;}#yiv8162875423 #yiv8162875423ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8162875423 #yiv8162875423ygrp-sponsor
#yiv8162875423ov li a {font-size:130%;text-decoration:none;}#yiv8162875423
#yiv8162875423ygrp-sponsor #yiv8162875423ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8162875423
#yiv8162875423ygrp-sponsor #yiv8162875423ov ul {margin:0;padding:0 0 0
8px;}#yiv8162875423 #yiv8162875423ygrp-text
{font-family:Georgia;}#yiv8162875423 #yiv8162875423ygrp-text p {margin:0 0 1em
0;}#yiv8162875423 #yiv8162875423ygrp-text tt {font-size:120%;}#yiv8162875423
#yiv8162875423ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8162875423
