Dear Mr Odong nando,
terima kasih atas responnya,
saya baca tapi tidak ada solusi untuk refreshnya tersebut.
regardscito akbar
Dari: "odong nando [email protected] [belajar-excel]"
<[email protected]>
Kepada: "[email protected]" <[email protected]>
Dikirim: Rabu, 2 Maret 2016 16:36
Judul: Bls: [belajar-excel] cara refresh otomatis file tautan Vlookup
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
#yiv9391548123 #yiv9391548123 -- #yiv9391548123ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9391548123
#yiv9391548123ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9391548123
#yiv9391548123ygrp-mkp #yiv9391548123hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9391548123 #yiv9391548123ygrp-mkp #yiv9391548123ads
{margin-bottom:10px;}#yiv9391548123 #yiv9391548123ygrp-mkp .yiv9391548123ad
{padding:0 0;}#yiv9391548123 #yiv9391548123ygrp-mkp .yiv9391548123ad p
{margin:0;}#yiv9391548123 #yiv9391548123ygrp-mkp .yiv9391548123ad a
{color:#0000ff;text-decoration:none;}#yiv9391548123 #yiv9391548123ygrp-sponsor
#yiv9391548123ygrp-lc {font-family:Arial;}#yiv9391548123
#yiv9391548123ygrp-sponsor #yiv9391548123ygrp-lc #yiv9391548123hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9391548123
#yiv9391548123ygrp-sponsor #yiv9391548123ygrp-lc .yiv9391548123ad
{margin-bottom:10px;padding:0 0;}#yiv9391548123 #yiv9391548123actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9391548123
#yiv9391548123activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9391548123
#yiv9391548123activity span {font-weight:700;}#yiv9391548123
#yiv9391548123activity span:first-child
{text-transform:uppercase;}#yiv9391548123 #yiv9391548123activity span a
{color:#5085b6;text-decoration:none;}#yiv9391548123 #yiv9391548123activity span
span {color:#ff7900;}#yiv9391548123 #yiv9391548123activity span
.yiv9391548123underline {text-decoration:underline;}#yiv9391548123
.yiv9391548123attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9391548123 .yiv9391548123attach div a
{text-decoration:none;}#yiv9391548123 .yiv9391548123attach img
{border:none;padding-right:5px;}#yiv9391548123 .yiv9391548123attach label
{display:block;margin-bottom:5px;}#yiv9391548123 .yiv9391548123attach label a
{text-decoration:none;}#yiv9391548123 blockquote {margin:0 0 0
4px;}#yiv9391548123 .yiv9391548123bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9391548123
.yiv9391548123bold a {text-decoration:none;}#yiv9391548123 dd.yiv9391548123last
p a {font-family:Verdana;font-weight:700;}#yiv9391548123 dd.yiv9391548123last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9391548123
dd.yiv9391548123last p span.yiv9391548123yshortcuts
{margin-right:0;}#yiv9391548123 div.yiv9391548123attach-table div div a
{text-decoration:none;}#yiv9391548123 div.yiv9391548123attach-table
{width:400px;}#yiv9391548123 div.yiv9391548123file-title a, #yiv9391548123
div.yiv9391548123file-title a:active, #yiv9391548123
div.yiv9391548123file-title a:hover, #yiv9391548123 div.yiv9391548123file-title
a:visited {text-decoration:none;}#yiv9391548123 div.yiv9391548123photo-title a,
#yiv9391548123 div.yiv9391548123photo-title a:active, #yiv9391548123
div.yiv9391548123photo-title a:hover, #yiv9391548123
div.yiv9391548123photo-title a:visited {text-decoration:none;}#yiv9391548123
div#yiv9391548123ygrp-mlmsg #yiv9391548123ygrp-msg p a
span.yiv9391548123yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9391548123
.yiv9391548123green {color:#628c2a;}#yiv9391548123 .yiv9391548123MsoNormal
{margin:0 0 0 0;}#yiv9391548123 o {font-size:0;}#yiv9391548123
#yiv9391548123photos div {float:left;width:72px;}#yiv9391548123
#yiv9391548123photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9391548123
#yiv9391548123photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9391548123
#yiv9391548123reco-category {font-size:77%;}#yiv9391548123
#yiv9391548123reco-desc {font-size:77%;}#yiv9391548123 .yiv9391548123replbq
{margin:4px;}#yiv9391548123 #yiv9391548123ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9391548123 #yiv9391548123ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9391548123
#yiv9391548123ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9391548123
#yiv9391548123ygrp-mlmsg select, #yiv9391548123 input, #yiv9391548123 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9391548123
#yiv9391548123ygrp-mlmsg pre, #yiv9391548123 code {font:115%
monospace;}#yiv9391548123 #yiv9391548123ygrp-mlmsg *
{line-height:1.22em;}#yiv9391548123 #yiv9391548123ygrp-mlmsg #yiv9391548123logo
{padding-bottom:10px;}#yiv9391548123 #yiv9391548123ygrp-msg p a
{font-family:Verdana;}#yiv9391548123 #yiv9391548123ygrp-msg
p#yiv9391548123attach-count span {color:#1E66AE;font-weight:700;}#yiv9391548123
#yiv9391548123ygrp-reco #yiv9391548123reco-head
{color:#ff7900;font-weight:700;}#yiv9391548123 #yiv9391548123ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9391548123 #yiv9391548123ygrp-sponsor
#yiv9391548123ov li a {font-size:130%;text-decoration:none;}#yiv9391548123
#yiv9391548123ygrp-sponsor #yiv9391548123ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9391548123
#yiv9391548123ygrp-sponsor #yiv9391548123ov ul {margin:0;padding:0 0 0
8px;}#yiv9391548123 #yiv9391548123ygrp-text
{font-family:Georgia;}#yiv9391548123 #yiv9391548123ygrp-text p {margin:0 0 1em
0;}#yiv9391548123 #yiv9391548123ygrp-text tt {font-size:120%;}#yiv9391548123
#yiv9391548123ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9391548123
