Re: [belajar-excel] proses input, pindah Sheet dan Edit pada excel 2007 lambat

Mon, 28 Nov 2016 19:20:07 -0800 

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 [email protected] [belajar-excel]" 
<[email protected]>
 To: [email protected] 
 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

Kirim email ke