Dear Master Excel,Mau tanya cara untuk cek otomatis pada report filter di pivot
table saat data bertambah gimana ya?
contoh pada gambar berikut
yang seharusnya di uncheck yang namanya SMARTBOX aja,
tapi tiap ada penambahan data, yang lain jadi ke uncheck juga.mohon masukannya
Best Regards, Fajar Fatahillah
On Friday, September 4, 2015 3:18 PM, "Sony Ario [email protected]
[belajar-excel]" <[email protected]> wrote:
Yup. Setelah baca petunjuk dari Mr. Kid, langsung saya lakukan :)
Terima kasih atas petunjuknya.
WassalamSony
2015-09-03 6:13 GMT+07:00 'Mr. Kid' [email protected] [belajar-excel]
<[email protected]>:
Hai Sony,
Sudahkah uncheck opsi Autofit column blabla dalam pivot table options ?
(klik kanan pivot table -> pivot table options -> tab layout & format ->
uncheck Autofit column blabla -> OK)
Wassalam,
Kid
2015-09-01 17:30 GMT+07:00 Sony Ario [email protected] [belajar-excel]
<[email protected]>:
Dear be excelers,Mohon bantuan. Saya punya sebuah pivot table yang sering
kali harus direfresh. Saya sudah set lebar kolom dengan lebar tertentu. Tapi
pada saat di refresh, lebar kolom berubah lagi. Sehingga data nya terlihat
####.Mohon dibantu caranya supaya lebar kolom tsb tidak berubah saat di
refresh.Terima kasih sebelumnya.Rgds
Sony
#yiv2702928995 #yiv2702928995 -- #yiv2702928995ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2702928995
#yiv2702928995ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2702928995
#yiv2702928995ygrp-mkp #yiv2702928995hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2702928995 #yiv2702928995ygrp-mkp #yiv2702928995ads
{margin-bottom:10px;}#yiv2702928995 #yiv2702928995ygrp-mkp .yiv2702928995ad
{padding:0 0;}#yiv2702928995 #yiv2702928995ygrp-mkp .yiv2702928995ad p
{margin:0;}#yiv2702928995 #yiv2702928995ygrp-mkp .yiv2702928995ad a
{color:#0000ff;text-decoration:none;}#yiv2702928995 #yiv2702928995ygrp-sponsor
#yiv2702928995ygrp-lc {font-family:Arial;}#yiv2702928995
#yiv2702928995ygrp-sponsor #yiv2702928995ygrp-lc #yiv2702928995hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2702928995
#yiv2702928995ygrp-sponsor #yiv2702928995ygrp-lc .yiv2702928995ad
{margin-bottom:10px;padding:0 0;}#yiv2702928995 #yiv2702928995actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2702928995
#yiv2702928995activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2702928995
#yiv2702928995activity span {font-weight:700;}#yiv2702928995
#yiv2702928995activity span:first-child
{text-transform:uppercase;}#yiv2702928995 #yiv2702928995activity span a
{color:#5085b6;text-decoration:none;}#yiv2702928995 #yiv2702928995activity span
span {color:#ff7900;}#yiv2702928995 #yiv2702928995activity span
.yiv2702928995underline {text-decoration:underline;}#yiv2702928995
.yiv2702928995attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2702928995 .yiv2702928995attach div a
{text-decoration:none;}#yiv2702928995 .yiv2702928995attach img
{border:none;padding-right:5px;}#yiv2702928995 .yiv2702928995attach label
{display:block;margin-bottom:5px;}#yiv2702928995 .yiv2702928995attach label a
{text-decoration:none;}#yiv2702928995 blockquote {margin:0 0 0
4px;}#yiv2702928995 .yiv2702928995bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2702928995
.yiv2702928995bold a {text-decoration:none;}#yiv2702928995 dd.yiv2702928995last
p a {font-family:Verdana;font-weight:700;}#yiv2702928995 dd.yiv2702928995last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2702928995
dd.yiv2702928995last p span.yiv2702928995yshortcuts
{margin-right:0;}#yiv2702928995 div.yiv2702928995attach-table div div a
{text-decoration:none;}#yiv2702928995 div.yiv2702928995attach-table
{width:400px;}#yiv2702928995 div.yiv2702928995file-title a, #yiv2702928995
div.yiv2702928995file-title a:active, #yiv2702928995
div.yiv2702928995file-title a:hover, #yiv2702928995 div.yiv2702928995file-title
a:visited {text-decoration:none;}#yiv2702928995 div.yiv2702928995photo-title a,
#yiv2702928995 div.yiv2702928995photo-title a:active, #yiv2702928995
div.yiv2702928995photo-title a:hover, #yiv2702928995
div.yiv2702928995photo-title a:visited {text-decoration:none;}#yiv2702928995
div#yiv2702928995ygrp-mlmsg #yiv2702928995ygrp-msg p a
span.yiv2702928995yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2702928995
.yiv2702928995green {color:#628c2a;}#yiv2702928995 .yiv2702928995MsoNormal
{margin:0 0 0 0;}#yiv2702928995 o {font-size:0;}#yiv2702928995
#yiv2702928995photos div {float:left;width:72px;}#yiv2702928995
#yiv2702928995photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv2702928995
#yiv2702928995photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2702928995
#yiv2702928995reco-category {font-size:77%;}#yiv2702928995
#yiv2702928995reco-desc {font-size:77%;}#yiv2702928995 .yiv2702928995replbq
{margin:4px;}#yiv2702928995 #yiv2702928995ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2702928995 #yiv2702928995ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2702928995
#yiv2702928995ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2702928995
#yiv2702928995ygrp-mlmsg select, #yiv2702928995 input, #yiv2702928995 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2702928995
#yiv2702928995ygrp-mlmsg pre, #yiv2702928995 code {font:115%
monospace;}#yiv2702928995 #yiv2702928995ygrp-mlmsg *
{line-height:1.22em;}#yiv2702928995 #yiv2702928995ygrp-mlmsg #yiv2702928995logo
{padding-bottom:10px;}#yiv2702928995 #yiv2702928995ygrp-msg p a
{font-family:Verdana;}#yiv2702928995 #yiv2702928995ygrp-msg
p#yiv2702928995attach-count span {color:#1E66AE;font-weight:700;}#yiv2702928995
#yiv2702928995ygrp-reco #yiv2702928995reco-head
{color:#ff7900;font-weight:700;}#yiv2702928995 #yiv2702928995ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2702928995 #yiv2702928995ygrp-sponsor
#yiv2702928995ov li a {font-size:130%;text-decoration:none;}#yiv2702928995
#yiv2702928995ygrp-sponsor #yiv2702928995ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2702928995
#yiv2702928995ygrp-sponsor #yiv2702928995ov ul {margin:0;padding:0 0 0
8px;}#yiv2702928995 #yiv2702928995ygrp-text
{font-family:Georgia;}#yiv2702928995 #yiv2702928995ygrp-text p {margin:0 0 1em
0;}#yiv2702928995 #yiv2702928995ygrp-text tt {font-size:120%;}#yiv2702928995
#yiv2702928995ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2702928995
