Dear Mr. Kid,
saya baru tau ada menu shortcut ini dan kemudian google, terima kasih mr.kid
atas sarannya.
ada satu pertanyaan lagi Mr. Kid,
Jika ingin Close all data tersebut dengan cara Shift + klik menu File, kenapa
tidak muncul ya Mr. Kid?
apakah perlu kondisi tertentu agar menu tersebut muncul.
terima kasih.
regardsakbar
Dari: "'Mr. Kid' [email protected] [belajar-excel]"
<[email protected]>
Kepada: BeExcel <[email protected]>
Dikirim: Kamis, 3 Maret 2016 15:14
Judul: Re: [belajar-excel] cara refresh otomatis file tautan Vlookup
Kalau nama file atau lokasi file yang dirujuk oleh sebuah formula link ke
workbook lain telah berubah, maka Excel akan menanyakan dimana file tersebut
walaupun nilai data di dalam file tidak ada yang diubah dan di-save.
Kalau nama file dan lokasinya tetap, data yang diubah sudah di-save, andaikan
tidak terupdate otomatis, buka file tersebut bersama-sama dengan workbook
berisi formula yang merujuk ke workbook lain. Lalu save as excel workspace
kalau tidak mau repot membuka satu per satu file yang dirujuk oleh formula.
2016-03-02 13:26 GMT+07:00 Cito Akbar [email protected] [belajar-excel]
<[email protected]>:
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
#yiv0067106707 #yiv0067106707 -- #yiv0067106707ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0067106707
#yiv0067106707ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0067106707
#yiv0067106707ygrp-mkp #yiv0067106707hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0067106707 #yiv0067106707ygrp-mkp #yiv0067106707ads
{margin-bottom:10px;}#yiv0067106707 #yiv0067106707ygrp-mkp .yiv0067106707ad
{padding:0 0;}#yiv0067106707 #yiv0067106707ygrp-mkp .yiv0067106707ad p
{margin:0;}#yiv0067106707 #yiv0067106707ygrp-mkp .yiv0067106707ad a
{color:#0000ff;text-decoration:none;}#yiv0067106707 #yiv0067106707ygrp-sponsor
#yiv0067106707ygrp-lc {font-family:Arial;}#yiv0067106707
#yiv0067106707ygrp-sponsor #yiv0067106707ygrp-lc #yiv0067106707hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0067106707
#yiv0067106707ygrp-sponsor #yiv0067106707ygrp-lc .yiv0067106707ad
{margin-bottom:10px;padding:0 0;}#yiv0067106707 #yiv0067106707actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0067106707
#yiv0067106707activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0067106707
#yiv0067106707activity span {font-weight:700;}#yiv0067106707
#yiv0067106707activity span:first-child
{text-transform:uppercase;}#yiv0067106707 #yiv0067106707activity span a
{color:#5085b6;text-decoration:none;}#yiv0067106707 #yiv0067106707activity span
span {color:#ff7900;}#yiv0067106707 #yiv0067106707activity span
.yiv0067106707underline {text-decoration:underline;}#yiv0067106707
.yiv0067106707attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0067106707 .yiv0067106707attach div a
{text-decoration:none;}#yiv0067106707 .yiv0067106707attach img
{border:none;padding-right:5px;}#yiv0067106707 .yiv0067106707attach label
{display:block;margin-bottom:5px;}#yiv0067106707 .yiv0067106707attach label a
{text-decoration:none;}#yiv0067106707 blockquote {margin:0 0 0
4px;}#yiv0067106707 .yiv0067106707bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0067106707
.yiv0067106707bold a {text-decoration:none;}#yiv0067106707 dd.yiv0067106707last
p a {font-family:Verdana;font-weight:700;}#yiv0067106707 dd.yiv0067106707last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0067106707
dd.yiv0067106707last p span.yiv0067106707yshortcuts
{margin-right:0;}#yiv0067106707 div.yiv0067106707attach-table div div a
{text-decoration:none;}#yiv0067106707 div.yiv0067106707attach-table
{width:400px;}#yiv0067106707 div.yiv0067106707file-title a, #yiv0067106707
div.yiv0067106707file-title a:active, #yiv0067106707
div.yiv0067106707file-title a:hover, #yiv0067106707 div.yiv0067106707file-title
a:visited {text-decoration:none;}#yiv0067106707 div.yiv0067106707photo-title a,
#yiv0067106707 div.yiv0067106707photo-title a:active, #yiv0067106707
div.yiv0067106707photo-title a:hover, #yiv0067106707
div.yiv0067106707photo-title a:visited {text-decoration:none;}#yiv0067106707
div#yiv0067106707ygrp-mlmsg #yiv0067106707ygrp-msg p a
span.yiv0067106707yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0067106707
.yiv0067106707green {color:#628c2a;}#yiv0067106707 .yiv0067106707MsoNormal
{margin:0 0 0 0;}#yiv0067106707 o {font-size:0;}#yiv0067106707
#yiv0067106707photos div {float:left;width:72px;}#yiv0067106707
#yiv0067106707photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0067106707
#yiv0067106707photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0067106707
#yiv0067106707reco-category {font-size:77%;}#yiv0067106707
#yiv0067106707reco-desc {font-size:77%;}#yiv0067106707 .yiv0067106707replbq
{margin:4px;}#yiv0067106707 #yiv0067106707ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0067106707 #yiv0067106707ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0067106707
#yiv0067106707ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0067106707
#yiv0067106707ygrp-mlmsg select, #yiv0067106707 input, #yiv0067106707 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0067106707
#yiv0067106707ygrp-mlmsg pre, #yiv0067106707 code {font:115%
monospace;}#yiv0067106707 #yiv0067106707ygrp-mlmsg *
{line-height:1.22em;}#yiv0067106707 #yiv0067106707ygrp-mlmsg #yiv0067106707logo
{padding-bottom:10px;}#yiv0067106707 #yiv0067106707ygrp-msg p a
{font-family:Verdana;}#yiv0067106707 #yiv0067106707ygrp-msg
p#yiv0067106707attach-count span {color:#1E66AE;font-weight:700;}#yiv0067106707
#yiv0067106707ygrp-reco #yiv0067106707reco-head
{color:#ff7900;font-weight:700;}#yiv0067106707 #yiv0067106707ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0067106707 #yiv0067106707ygrp-sponsor
#yiv0067106707ov li a {font-size:130%;text-decoration:none;}#yiv0067106707
#yiv0067106707ygrp-sponsor #yiv0067106707ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0067106707
#yiv0067106707ygrp-sponsor #yiv0067106707ov ul {margin:0;padding:0 0 0
8px;}#yiv0067106707 #yiv0067106707ygrp-text
{font-family:Georgia;}#yiv0067106707 #yiv0067106707ygrp-text p {margin:0 0 1em
0;}#yiv0067106707 #yiv0067106707ygrp-text tt {font-size:120%;}#yiv0067106707
#yiv0067106707ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0067106707
