Saya pernah mengalami kasus serupa, dimana ada begitu banyak shape yang tidak terlihat secara kasat mata. Coba lakukan langkah ini :- Cek apakah waktu loading ada "Add-In".- Hapus baris atau kolom kosong di semua Sheets.- Cek apakah ada peringatan circular reference.- Value formula yang tidak perlu sebagai formula termasuk link formula- Kurangi Format yang tidak perlu.- Hapus Shape pada Sheet dengan Macro berikut ini : Sub hapus_shape() Dim wsh As Worksheet Dim sh As Shape Set wsh = Worksheets("nama sheet") For Each sh In wsh.Shapes sh.Delete Next End Sub Kalau ga berhasil juga, coba buat workbook baru dan copy masing2 sheet sebatas yang ada isinya saja. SImpan dengan nama file baru (Kalau mau boleh langsung lakukan langkah ini)/ Salam,HK From: "Agus Salim Al Ghozali al.ghozali1...@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> To: belajar-excel@yahoogroups.com Sent: Tuesday, 29 November 2016, 9:40 Subject: [belajar-excel] proses input, pindah Sheet dan Edit pada excel 2007 lambat Dear Mas, Mohon bantuan Mas, File Excel saya loadingnya sangat lambat setelah saya tambah rows, jadi untuk input data, edit data dan pindah sheet jadi lambat mas. terimakasih sebelumnya salam agus salim Nst #yiv4764967876 #yiv4764967876 -- #yiv4764967876ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4764967876 #yiv4764967876ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4764967876 #yiv4764967876ygrp-mkp #yiv4764967876hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4764967876 #yiv4764967876ygrp-mkp #yiv4764967876ads {margin-bottom:10px;}#yiv4764967876 #yiv4764967876ygrp-mkp .yiv4764967876ad {padding:0 0;}#yiv4764967876 #yiv4764967876ygrp-mkp .yiv4764967876ad p {margin:0;}#yiv4764967876 #yiv4764967876ygrp-mkp .yiv4764967876ad a {color:#0000ff;text-decoration:none;}#yiv4764967876 #yiv4764967876ygrp-sponsor #yiv4764967876ygrp-lc {font-family:Arial;}#yiv4764967876 #yiv4764967876ygrp-sponsor #yiv4764967876ygrp-lc #yiv4764967876hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4764967876 #yiv4764967876ygrp-sponsor #yiv4764967876ygrp-lc .yiv4764967876ad {margin-bottom:10px;padding:0 0;}#yiv4764967876 #yiv4764967876actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4764967876 #yiv4764967876activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4764967876 #yiv4764967876activity span {font-weight:700;}#yiv4764967876 #yiv4764967876activity span:first-child {text-transform:uppercase;}#yiv4764967876 #yiv4764967876activity span a {color:#5085b6;text-decoration:none;}#yiv4764967876 #yiv4764967876activity span span {color:#ff7900;}#yiv4764967876 #yiv4764967876activity span .yiv4764967876underline {text-decoration:underline;}#yiv4764967876 .yiv4764967876attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4764967876 .yiv4764967876attach div a {text-decoration:none;}#yiv4764967876 .yiv4764967876attach img {border:none;padding-right:5px;}#yiv4764967876 .yiv4764967876attach label {display:block;margin-bottom:5px;}#yiv4764967876 .yiv4764967876attach label a {text-decoration:none;}#yiv4764967876 blockquote {margin:0 0 0 4px;}#yiv4764967876 .yiv4764967876bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4764967876 .yiv4764967876bold a {text-decoration:none;}#yiv4764967876 dd.yiv4764967876last p a {font-family:Verdana;font-weight:700;}#yiv4764967876 dd.yiv4764967876last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4764967876 dd.yiv4764967876last p span.yiv4764967876yshortcuts {margin-right:0;}#yiv4764967876 div.yiv4764967876attach-table div div a {text-decoration:none;}#yiv4764967876 div.yiv4764967876attach-table {width:400px;}#yiv4764967876 div.yiv4764967876file-title a, #yiv4764967876 div.yiv4764967876file-title a:active, #yiv4764967876 div.yiv4764967876file-title a:hover, #yiv4764967876 div.yiv4764967876file-title a:visited {text-decoration:none;}#yiv4764967876 div.yiv4764967876photo-title a, #yiv4764967876 div.yiv4764967876photo-title a:active, #yiv4764967876 div.yiv4764967876photo-title a:hover, #yiv4764967876 div.yiv4764967876photo-title a:visited {text-decoration:none;}#yiv4764967876 div#yiv4764967876ygrp-mlmsg #yiv4764967876ygrp-msg p a span.yiv4764967876yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4764967876 .yiv4764967876green {color:#628c2a;}#yiv4764967876 .yiv4764967876MsoNormal {margin:0 0 0 0;}#yiv4764967876 o {font-size:0;}#yiv4764967876 #yiv4764967876photos div {float:left;width:72px;}#yiv4764967876 #yiv4764967876photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4764967876 #yiv4764967876photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4764967876 #yiv4764967876reco-category {font-size:77%;}#yiv4764967876 #yiv4764967876reco-desc {font-size:77%;}#yiv4764967876 .yiv4764967876replbq {margin:4px;}#yiv4764967876 #yiv4764967876ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4764967876 #yiv4764967876ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4764967876 #yiv4764967876ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4764967876 #yiv4764967876ygrp-mlmsg select, #yiv4764967876 input, #yiv4764967876 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4764967876 #yiv4764967876ygrp-mlmsg pre, #yiv4764967876 code {font:115% monospace;}#yiv4764967876 #yiv4764967876ygrp-mlmsg * {line-height:1.22em;}#yiv4764967876 #yiv4764967876ygrp-mlmsg #yiv4764967876logo {padding-bottom:10px;}#yiv4764967876 #yiv4764967876ygrp-msg p a {font-family:Verdana;}#yiv4764967876 #yiv4764967876ygrp-msg p#yiv4764967876attach-count span {color:#1E66AE;font-weight:700;}#yiv4764967876 #yiv4764967876ygrp-reco #yiv4764967876reco-head {color:#ff7900;font-weight:700;}#yiv4764967876 #yiv4764967876ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4764967876 #yiv4764967876ygrp-sponsor #yiv4764967876ov li a {font-size:130%;text-decoration:none;}#yiv4764967876 #yiv4764967876ygrp-sponsor #yiv4764967876ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4764967876 #yiv4764967876ygrp-sponsor #yiv4764967876ov ul {margin:0;padding:0 0 0 8px;}#yiv4764967876 #yiv4764967876ygrp-text {font-family:Georgia;}#yiv4764967876 #yiv4764967876ygrp-text p {margin:0 0 1em 0;}#yiv4764967876 #yiv4764967876ygrp-text tt {font-size:120%;}#yiv4764967876 #yiv4764967876ygrp-vital ul li:last-child {border-right:none !important;}#yiv4764967876
Re: [belajar-excel] proses input, pindah Sheet dan Edit pada excel 2007 lambat
hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel] Mon, 28 Nov 2016 19:20:07 -0800
- [belaj... Agus Salim Al Ghozali al.ghozali1...@gmail.com [belajar-excel]
- [... Agus Salim Al Ghozali al.ghozali1...@gmail.com [belajar-excel]
- [... Agus Salim Al Ghozali al.ghozali1...@gmail.com [belajar-excel]
- ... hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]
- ... hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]
- ... Agus Salim Al Ghozali al.ghozali1...@gmail.com [belajar-excel]
- ... hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]