<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-7241470904841227586</id><updated>2024-11-08T22:23:20.234+07:00</updated><category term="eorenmh"/><category term="blog"/><category term="internet"/><category term="tips"/><category term="broadband"/><category term="mobile"/><category term="telecommunication"/><category term="wimax"/><category term="ringkasan"/><category term="microworkers"/><category term="thoughts"/><category term="windows"/><category term="tips n trik Excel"/><category term="android"/><category term="tech"/><category term="berita"/><category term="blade"/><category term="adsense"/><category term="furniture"/><category term="google"/><category term="istiqomah"/><category term="kisah"/><category term="movie"/><category term="teespring"/><category term="template"/><category term="Erkin Bekbolotov"/><category term="VBA macro"/><category term="amazon"/><category term="idr-clickit"/><category term="mikrotik"/><category term="mybux.me"/><category term="ngiklan"/><category term="rapidworkers"/><category term="sepakbola"/><category term="tv"/><category term="twilight"/><category term="youtube"/><title type='text'>eorenmh</title><subtitle type='html'>selalu mencoba untuk Istiqomah</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default?start-index=26&amp;max-results=25&amp;redirect=false'/><author><name>miersun</name><uri>http://www.blogger.com/profile/11086683349717103090</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='28' src='http://2.bp.blogspot.com/_tQs_daNjHiw/Shf3qlU-m-I/AAAAAAAAAAM/Uh0dBtigM1I/s1600-R/avatar12689_2.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>153</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-5553081048902881610</id><published>2021-08-18T19:10:00.000+07:00</published><updated>2021-08-18T19:11:17.225+07:00</updated><title type='text'>males karo uwong cawe2</title><content type='html'>&lt;div dir=&quot;ltr&quot;&gt;&lt;div dir=&quot;ltr&quot; class=&quot;gmail_signature&quot; data-smartmail=&quot;gmail_signature&quot;&gt;&lt;div dir=&quot;ltr&quot;&gt;&lt;div&gt;JIANCUOOOOKKK!!!&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;  </content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/5553081048902881610/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2021/08/males-karo-uwong-cawe2.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/5553081048902881610'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/5553081048902881610'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2021/08/males-karo-uwong-cawe2.html' title='males karo uwong cawe2'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-6620147206340520044</id><published>2021-08-18T15:18:00.000+07:00</published><updated>2021-08-18T15:19:34.596+07:00</updated><title type='text'>cukk</title><content type='html'>&lt;div dir=&quot;ltr&quot;&gt;&lt;div dir=&quot;ltr&quot; class=&quot;gmail_signature&quot; data-smartmail=&quot;gmail_signature&quot;&gt;&lt;div dir=&quot;ltr&quot;&gt;&lt;div&gt;dikon monitor gak dilakoni&lt;/div&gt;&lt;div&gt;akhire mbendol kabeh nagn aku maneh&lt;/div&gt;&lt;div&gt;cuk ancukk&lt;/div&gt;&lt;div&gt;&lt;br&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;  </content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/6620147206340520044/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2021/08/cukk.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/6620147206340520044'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/6620147206340520044'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2021/08/cukk.html' title='cukk'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-1382084573325406893</id><published>2018-02-04T22:46:00.002+07:00</published><updated>2018-08-09T15:51:09.965+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="tips n trik Excel"/><title type='text'>Penyebab Rumus Excel Tidak Berfungsi</title><content type='html'>&lt;span style=&quot;color: black;&quot;&gt;Dalam profesi saya yang sering meng-&lt;i&gt;copy&lt;/i&gt;-&lt;i&gt;paste&lt;/i&gt; banyak formula (misal, VLOOKUP), terkadang saya menemukan situasi dimana formula-formula tersebut sama persis dengan formula sumber nya.&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;596&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXvWZMy9FLaXRoKpmqyfCJCiqu1kXUptH-8eQjpwLVo5YXVw0jAf4676iUgjuqP2sz8ueFzmcyHXVGorJiDaWAyMatbXP8tsb_mZzWHRTtDTuKBvZ37OddnrXvMLPr6P8f2O_P3nE7Tt7D/s1600-h/image%25255B10%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgonbi85dZ0bONMRLXHmjiuVKmw9ByoPxck8nPIbCT2yzZUfU5r_80ghg63qLAFbDjF8xe_r2zBCdEv0lav_DeVp4ZZrLwt3WR3fJvKndGQCn4_Om8HHpMyhHZT1VeaCtVbndIhzUM6X6Yb/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;144&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;596&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 1&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;color: black;&quot;&gt;Pada gambar 1, saya akan meng-&lt;i&gt;copy&lt;/i&gt; formula pada cell B1 ke bawah&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAW79uguCZptWe5FfwiMsSYjY2N2uq_mxI9PdvOIRR7cpkOyhL8QQ_zs2RHgFW3mF_55umnNeq56zWRrZ9pZuxE8uolWQ9oc9Rj7TDAazDQHdA6KVkuX19v9mTBqhs7sbCuDvC4ONVKJnu/s1600-h/image%25255B21%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwyJQAedAm6P58ATA8ZyEVHVd4C2UHF3N30oAaC4UNbQQjdKll0rRz7WSeGbhKU_qT2YnwSo4wr8LcnAdbNWqN2Ddk4gG4XyksIbAUJp0dLgFlnqURShJCt5cwQRRp8ConPTLaaImTnrSg/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;144&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 2&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;Namun terjadilah seperti pada Gambar 2, yaitu formula tidak otomatis ter-&lt;i&gt;update. &lt;/i&gt;Hal ini bisa diatasi dengan cara memilih satu persatu cell, meng-edit-nya (tekan F2) dan Enter (lihat Gambar 3).&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;Namun hal ini tentunya akan sangat melelahkan dan menghabiskan waktu jika kita berurusan dengan ribuan formula, bukan?&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHmafk2cwnGnvtDDDATIPpAX2hWfagQ5cfNHeDpSRaOB4bBOVcrXN71dnqsDg1E-jjCtMV8D1iSp9mjXGLkFP2Vq-jKQQ2RD3kvbaRY98aDMOK7jmE0TUWHy8z07enZOn354JWYJfHXB_q/s1600-h/image%25255B28%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgv9Uwo_NVAxs3viK3gYfOT1j4g9bPeQEae15XpL3UhYOEdqqurl-qxY1Mrk7HtrxR5bOQ5bxrZxpLVmhDt1tV-nyzZD0KW5eqo6V1KMuq1cmE6HhS45SJOysIdtJC4HCh61UQFDatPsFWm/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;144&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 3&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;color: black;&quot;&gt;Setelah &lt;i&gt;googling&lt;/i&gt;, maka saya menemukan bahwa ada opsi di Excel terkait hal ini. Dan ini adalah cara mengatasinya :&lt;/span&gt;&lt;br /&gt;
&lt;ol&gt;
&lt;li&gt;&lt;span style=&quot;color: black;&quot;&gt;Klik “File” lalu klik “Options” &lt;/span&gt; &lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;color: black;&quot;&gt;Klik “Formulas” (pilihan kedua di bawah “General” lalu lihat ke sebelah kanan &lt;/span&gt; &lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;color: black;&quot;&gt;Pastikan “Workbook Calculation” menjadi “Automatic”&lt;/span&gt;&lt;/li&gt;
&lt;/ol&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSYYSXhuKqAEzaviMaqK5Jx0T4rTA75xrSRbmwqdxDjn63D57-3mblvlN81bKRVhp9Sqzc0RApOxWYzXUYZjswJ8IMpGUrnhSDTvH576FV8f320ch0Z-oRhgCJ8XplHCZ2kAaXQ_FFo-dV/s1600-h/image%25255B35%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;120&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnUWM7kPCilQDofaUCQ3jj45CJoqJVvE9nT26f4-dcUferNfRambj4gfWTsXzSN-l-dSk0PaZsFotR0P6OlE2DaowezKh3T-EOeAGhLtHZLMS0jiyYtBBAm7cUCXTNqjwFicOiJuf_2W9c/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;244&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 4&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;color: black;&quot;&gt;Saya kurang tahu mengapa situasi tersebut bisa terjadi. Mungkin ada keyboard &lt;i&gt;shortcut&lt;/i&gt; yang menjadikan Workbook Calculation menjadi “Manual” dan teraktifkan secara tidak sengaja.&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;color: black;&quot;&gt;&lt;b&gt;&lt;u&gt;Update 30 Juni 2016&lt;/u&gt;&lt;/b&gt; : Jika ingin solusi lebih cepat, misalnya ingin segera mengetahui perubahan yang disebabkan oleh formula, bisa tekan tombol F9&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://eorenmh.blogspot.com/2013/10/formula-excel-tidak-berfungsi.html&quot;&gt;Sumber&lt;/a&gt;
&lt;br /&gt;
Anda mungkin tertarik untuk membaca ini juga :&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;&lt;a href=&quot;http://www.anuneanu.com/2015/01/cara-crack-password-macro-vba-excel.html&quot; target=&quot;_blank&quot;&gt;Cara Crack Password Macro VBA Excel&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;http://www.anuneanu.com/2018/08/macro-excel-untuk-download-gambar.html&quot; target=&quot;_blank&quot;&gt;Macro VBA Excel untuk Download Gambar Google Maps dan Street View&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/1382084573325406893/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2018/02/penyebab-rumus-excel-tidak-berfungsi.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/1382084573325406893'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/1382084573325406893'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2018/02/penyebab-rumus-excel-tidak-berfungsi.html' title='Penyebab Rumus Excel Tidak Berfungsi'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgonbi85dZ0bONMRLXHmjiuVKmw9ByoPxck8nPIbCT2yzZUfU5r_80ghg63qLAFbDjF8xe_r2zBCdEv0lav_DeVp4ZZrLwt3WR3fJvKndGQCn4_Om8HHpMyhHZT1VeaCtVbndIhzUM6X6Yb/s72-c?imgmax=800" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-2010350355497322653</id><published>2018-02-04T22:45:00.003+07:00</published><updated>2018-08-09T15:48:30.839+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="tips n trik Excel"/><title type='text'>Penyebab Rumus VLOOKUP TIdak Berfungsi</title><content type='html'>&lt;span style=&quot;color: black;&quot;&gt;Dalam profesi saya yang sering meng-&lt;i&gt;copy&lt;/i&gt;-&lt;i&gt;paste&lt;/i&gt; banyak formula (misal, VLOOKUP), terkadang saya menemukan situasi dimana formula-formula tersebut sama persis dengan formula sumber nya.&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;596&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXvWZMy9FLaXRoKpmqyfCJCiqu1kXUptH-8eQjpwLVo5YXVw0jAf4676iUgjuqP2sz8ueFzmcyHXVGorJiDaWAyMatbXP8tsb_mZzWHRTtDTuKBvZ37OddnrXvMLPr6P8f2O_P3nE7Tt7D/s1600-h/image%25255B10%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgonbi85dZ0bONMRLXHmjiuVKmw9ByoPxck8nPIbCT2yzZUfU5r_80ghg63qLAFbDjF8xe_r2zBCdEv0lav_DeVp4ZZrLwt3WR3fJvKndGQCn4_Om8HHpMyhHZT1VeaCtVbndIhzUM6X6Yb/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;144&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;596&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 1&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;color: black;&quot;&gt;Pada gambar 1, saya akan meng-&lt;i&gt;copy&lt;/i&gt; formula pada cell B1 ke bawah&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAW79uguCZptWe5FfwiMsSYjY2N2uq_mxI9PdvOIRR7cpkOyhL8QQ_zs2RHgFW3mF_55umnNeq56zWRrZ9pZuxE8uolWQ9oc9Rj7TDAazDQHdA6KVkuX19v9mTBqhs7sbCuDvC4ONVKJnu/s1600-h/image%25255B21%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwyJQAedAm6P58ATA8ZyEVHVd4C2UHF3N30oAaC4UNbQQjdKll0rRz7WSeGbhKU_qT2YnwSo4wr8LcnAdbNWqN2Ddk4gG4XyksIbAUJp0dLgFlnqURShJCt5cwQRRp8ConPTLaaImTnrSg/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;144&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 2&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;Namun terjadilah seperti pada Gambar 2, yaitu formula tidak otomatis ter-&lt;i&gt;update. &lt;/i&gt;Hal ini bisa diatasi dengan cara memilih satu persatu cell, meng-edit-nya (tekan F2) dan Enter (lihat Gambar 3).&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;Namun hal ini tentunya akan sangat melelahkan dan menghabiskan waktu jika kita berurusan dengan ribuan formula, bukan?&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHmafk2cwnGnvtDDDATIPpAX2hWfagQ5cfNHeDpSRaOB4bBOVcrXN71dnqsDg1E-jjCtMV8D1iSp9mjXGLkFP2Vq-jKQQ2RD3kvbaRY98aDMOK7jmE0TUWHy8z07enZOn354JWYJfHXB_q/s1600-h/image%25255B28%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgv9Uwo_NVAxs3viK3gYfOT1j4g9bPeQEae15XpL3UhYOEdqqurl-qxY1Mrk7HtrxR5bOQ5bxrZxpLVmhDt1tV-nyzZD0KW5eqo6V1KMuq1cmE6HhS45SJOysIdtJC4HCh61UQFDatPsFWm/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;144&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 3&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;color: black;&quot;&gt;Setelah &lt;i&gt;googling&lt;/i&gt;, maka saya menemukan bahwa ada opsi di Excel terkait hal ini. Dan ini adalah cara mengatasinya :&lt;/span&gt;&lt;br /&gt;
&lt;ol&gt;
&lt;li&gt;&lt;span style=&quot;color: black;&quot;&gt;Klik “File” lalu klik “Options” &lt;/span&gt; &lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;color: black;&quot;&gt;Klik “Formulas” (pilihan kedua di bawah “General” lalu lihat ke sebelah kanan &lt;/span&gt; &lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;color: black;&quot;&gt;Pastikan “Workbook Calculation” menjadi “Automatic”&lt;/span&gt;&lt;/li&gt;
&lt;/ol&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSYYSXhuKqAEzaviMaqK5Jx0T4rTA75xrSRbmwqdxDjn63D57-3mblvlN81bKRVhp9Sqzc0RApOxWYzXUYZjswJ8IMpGUrnhSDTvH576FV8f320ch0Z-oRhgCJ8XplHCZ2kAaXQ_FFo-dV/s1600-h/image%25255B35%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;120&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnUWM7kPCilQDofaUCQ3jj45CJoqJVvE9nT26f4-dcUferNfRambj4gfWTsXzSN-l-dSk0PaZsFotR0P6OlE2DaowezKh3T-EOeAGhLtHZLMS0jiyYtBBAm7cUCXTNqjwFicOiJuf_2W9c/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;244&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 4&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;color: black;&quot;&gt;Saya kurang tahu mengapa situasi tersebut bisa terjadi. Mungkin ada keyboard &lt;i&gt;shortcut&lt;/i&gt; yang menjadikan Workbook Calculation menjadi “Manual” dan teraktifkan secara tidak sengaja.&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;color: black;&quot;&gt;&lt;b&gt;&lt;u&gt;Update 30 Juni 2016&lt;/u&gt;&lt;/b&gt; : Jika ingin solusi lebih cepat, misalnya ingin segera mengetahui perubahan yang disebabkan oleh formula, bisa tekan tombol F9&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;&lt;/span&gt;

&lt;br /&gt;
&lt;a href=&quot;http://eorenmh.blogspot.com/2013/10/formula-excel-tidak-berfungsi.html&quot;&gt;Sumber&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Anda mungkin tertarik untuk membaca ini juga :&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;&lt;a href=&quot;http://www.anuneanu.com/2015/01/cara-crack-password-macro-vba-excel.html&quot; target=&quot;_blank&quot;&gt;Cara Crack Password Macro VBA Excel&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;http://www.anuneanu.com/2018/08/macro-excel-untuk-download-gambar.html&quot; target=&quot;_blank&quot;&gt;Macro VBA Excel untuk Download Gambar Google Maps dan Street View&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/2010350355497322653/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2018/02/penyebab-rumus-vlookup-tidak-berfungsi.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/2010350355497322653'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/2010350355497322653'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2018/02/penyebab-rumus-vlookup-tidak-berfungsi.html' title='Penyebab Rumus VLOOKUP TIdak Berfungsi'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgonbi85dZ0bONMRLXHmjiuVKmw9ByoPxck8nPIbCT2yzZUfU5r_80ghg63qLAFbDjF8xe_r2zBCdEv0lav_DeVp4ZZrLwt3WR3fJvKndGQCn4_Om8HHpMyhHZT1VeaCtVbndIhzUM6X6Yb/s72-c?imgmax=800" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-8976144299589963149</id><published>2018-02-04T22:43:00.002+07:00</published><updated>2018-02-04T22:43:31.482+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="tips n trik Excel"/><title type='text'>Rumus Excel Tidak Berfungsi</title><content type='html'>&lt;span style=&quot;color: black;&quot;&gt;Dalam profesi saya yang sering meng-&lt;i&gt;copy&lt;/i&gt;-&lt;i&gt;paste&lt;/i&gt; banyak formula (misal, VLOOKUP), terkadang saya menemukan situasi dimana formula-formula tersebut sama persis dengan formula sumber nya.&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;596&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXvWZMy9FLaXRoKpmqyfCJCiqu1kXUptH-8eQjpwLVo5YXVw0jAf4676iUgjuqP2sz8ueFzmcyHXVGorJiDaWAyMatbXP8tsb_mZzWHRTtDTuKBvZ37OddnrXvMLPr6P8f2O_P3nE7Tt7D/s1600-h/image%25255B10%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgonbi85dZ0bONMRLXHmjiuVKmw9ByoPxck8nPIbCT2yzZUfU5r_80ghg63qLAFbDjF8xe_r2zBCdEv0lav_DeVp4ZZrLwt3WR3fJvKndGQCn4_Om8HHpMyhHZT1VeaCtVbndIhzUM6X6Yb/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;144&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;596&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 1&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;color: black;&quot;&gt;Pada gambar 1, saya akan meng-&lt;i&gt;copy&lt;/i&gt; formula pada cell B1 ke bawah&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAW79uguCZptWe5FfwiMsSYjY2N2uq_mxI9PdvOIRR7cpkOyhL8QQ_zs2RHgFW3mF_55umnNeq56zWRrZ9pZuxE8uolWQ9oc9Rj7TDAazDQHdA6KVkuX19v9mTBqhs7sbCuDvC4ONVKJnu/s1600-h/image%25255B21%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwyJQAedAm6P58ATA8ZyEVHVd4C2UHF3N30oAaC4UNbQQjdKll0rRz7WSeGbhKU_qT2YnwSo4wr8LcnAdbNWqN2Ddk4gG4XyksIbAUJp0dLgFlnqURShJCt5cwQRRp8ConPTLaaImTnrSg/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;144&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 2&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;Namun terjadilah seperti pada Gambar 2, yaitu formula tidak otomatis ter-&lt;i&gt;update. &lt;/i&gt;Hal ini bisa diatasi dengan cara memilih satu persatu cell, meng-edit-nya (tekan F2) dan Enter (lihat Gambar 3).&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;Namun hal ini tentunya akan sangat melelahkan dan menghabiskan waktu jika kita berurusan dengan ribuan formula, bukan?&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHmafk2cwnGnvtDDDATIPpAX2hWfagQ5cfNHeDpSRaOB4bBOVcrXN71dnqsDg1E-jjCtMV8D1iSp9mjXGLkFP2Vq-jKQQ2RD3kvbaRY98aDMOK7jmE0TUWHy8z07enZOn354JWYJfHXB_q/s1600-h/image%25255B28%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgv9Uwo_NVAxs3viK3gYfOT1j4g9bPeQEae15XpL3UhYOEdqqurl-qxY1Mrk7HtrxR5bOQ5bxrZxpLVmhDt1tV-nyzZD0KW5eqo6V1KMuq1cmE6HhS45SJOysIdtJC4HCh61UQFDatPsFWm/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;144&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 3&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;color: black;&quot;&gt;Setelah &lt;i&gt;googling&lt;/i&gt;, maka saya menemukan bahwa ada opsi di Excel terkait hal ini. Dan ini adalah cara mengatasinya :&lt;/span&gt;&lt;br /&gt;
&lt;ol&gt;
&lt;li&gt;&lt;span style=&quot;color: black;&quot;&gt;Klik “File” lalu klik “Options” &lt;/span&gt; &lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;color: black;&quot;&gt;Klik “Formulas” (pilihan kedua di bawah “General” lalu lihat ke sebelah kanan &lt;/span&gt; &lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;color: black;&quot;&gt;Pastikan “Workbook Calculation” menjadi “Automatic”&lt;/span&gt;&lt;/li&gt;
&lt;/ol&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSYYSXhuKqAEzaviMaqK5Jx0T4rTA75xrSRbmwqdxDjn63D57-3mblvlN81bKRVhp9Sqzc0RApOxWYzXUYZjswJ8IMpGUrnhSDTvH576FV8f320ch0Z-oRhgCJ8XplHCZ2kAaXQ_FFo-dV/s1600-h/image%25255B35%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;120&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnUWM7kPCilQDofaUCQ3jj45CJoqJVvE9nT26f4-dcUferNfRambj4gfWTsXzSN-l-dSk0PaZsFotR0P6OlE2DaowezKh3T-EOeAGhLtHZLMS0jiyYtBBAm7cUCXTNqjwFicOiJuf_2W9c/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;244&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 4&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;color: black;&quot;&gt;Saya kurang tahu mengapa situasi tersebut bisa terjadi. Mungkin ada keyboard &lt;i&gt;shortcut&lt;/i&gt; yang menjadikan Workbook Calculation menjadi “Manual” dan teraktifkan secara tidak sengaja.&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;color: black;&quot;&gt;&lt;b&gt;&lt;u&gt;Update 30 Juni 2016&lt;/u&gt;&lt;/b&gt; : Jika ingin solusi lebih cepat, misalnya ingin segera mengetahui perubahan yang disebabkan oleh formula, bisa tekan tombol F9&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://eorenmh.blogspot.com/2013/10/formula-excel-tidak-berfungsi.html&quot;&gt;Sumber&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/8976144299589963149/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2018/02/rumus-excel-tidak-berfungsi.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/8976144299589963149'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/8976144299589963149'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2018/02/rumus-excel-tidak-berfungsi.html' title='Rumus Excel Tidak Berfungsi'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgonbi85dZ0bONMRLXHmjiuVKmw9ByoPxck8nPIbCT2yzZUfU5r_80ghg63qLAFbDjF8xe_r2zBCdEv0lav_DeVp4ZZrLwt3WR3fJvKndGQCn4_Om8HHpMyhHZT1VeaCtVbndIhzUM6X6Yb/s72-c?imgmax=800" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-3849550110379010060</id><published>2018-02-04T22:42:00.003+07:00</published><updated>2018-08-09T15:50:09.891+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="tips n trik Excel"/><title type='text'>Mengatasi Rumus VLOOKUP Tidak Berfungsi</title><content type='html'>&lt;span style=&quot;color: black;&quot;&gt;Dalam profesi saya yang sering meng-&lt;i&gt;copy&lt;/i&gt;-&lt;i&gt;paste&lt;/i&gt; banyak formula (misal, VLOOKUP), terkadang saya menemukan situasi dimana formula-formula tersebut sama persis dengan formula sumber nya.&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;596&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXvWZMy9FLaXRoKpmqyfCJCiqu1kXUptH-8eQjpwLVo5YXVw0jAf4676iUgjuqP2sz8ueFzmcyHXVGorJiDaWAyMatbXP8tsb_mZzWHRTtDTuKBvZ37OddnrXvMLPr6P8f2O_P3nE7Tt7D/s1600-h/image%25255B10%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgonbi85dZ0bONMRLXHmjiuVKmw9ByoPxck8nPIbCT2yzZUfU5r_80ghg63qLAFbDjF8xe_r2zBCdEv0lav_DeVp4ZZrLwt3WR3fJvKndGQCn4_Om8HHpMyhHZT1VeaCtVbndIhzUM6X6Yb/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;144&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;596&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 1&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;color: black;&quot;&gt;Pada gambar 1, saya akan meng-&lt;i&gt;copy&lt;/i&gt; formula pada cell B1 ke bawah&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAW79uguCZptWe5FfwiMsSYjY2N2uq_mxI9PdvOIRR7cpkOyhL8QQ_zs2RHgFW3mF_55umnNeq56zWRrZ9pZuxE8uolWQ9oc9Rj7TDAazDQHdA6KVkuX19v9mTBqhs7sbCuDvC4ONVKJnu/s1600-h/image%25255B21%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwyJQAedAm6P58ATA8ZyEVHVd4C2UHF3N30oAaC4UNbQQjdKll0rRz7WSeGbhKU_qT2YnwSo4wr8LcnAdbNWqN2Ddk4gG4XyksIbAUJp0dLgFlnqURShJCt5cwQRRp8ConPTLaaImTnrSg/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;144&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 2&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;Namun terjadilah seperti pada Gambar 2, yaitu formula tidak otomatis ter-&lt;i&gt;update. &lt;/i&gt;Hal ini bisa diatasi dengan cara memilih satu persatu cell, meng-edit-nya (tekan F2) dan Enter (lihat Gambar 3).&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;Namun hal ini tentunya akan sangat melelahkan dan menghabiskan waktu jika kita berurusan dengan ribuan formula, bukan?&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHmafk2cwnGnvtDDDATIPpAX2hWfagQ5cfNHeDpSRaOB4bBOVcrXN71dnqsDg1E-jjCtMV8D1iSp9mjXGLkFP2Vq-jKQQ2RD3kvbaRY98aDMOK7jmE0TUWHy8z07enZOn354JWYJfHXB_q/s1600-h/image%25255B28%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgv9Uwo_NVAxs3viK3gYfOT1j4g9bPeQEae15XpL3UhYOEdqqurl-qxY1Mrk7HtrxR5bOQ5bxrZxpLVmhDt1tV-nyzZD0KW5eqo6V1KMuq1cmE6HhS45SJOysIdtJC4HCh61UQFDatPsFWm/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;144&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 3&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;color: black;&quot;&gt;Setelah &lt;i&gt;googling&lt;/i&gt;, maka saya menemukan bahwa ada opsi di Excel terkait hal ini. Dan ini adalah cara mengatasinya :&lt;/span&gt;&lt;br /&gt;
&lt;ol&gt;
&lt;li&gt;&lt;span style=&quot;color: black;&quot;&gt;Klik “File” lalu klik “Options” &lt;/span&gt; &lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;color: black;&quot;&gt;Klik “Formulas” (pilihan kedua di bawah “General” lalu lihat ke sebelah kanan &lt;/span&gt; &lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;color: black;&quot;&gt;Pastikan “Workbook Calculation” menjadi “Automatic”&lt;/span&gt;&lt;/li&gt;
&lt;/ol&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSYYSXhuKqAEzaviMaqK5Jx0T4rTA75xrSRbmwqdxDjn63D57-3mblvlN81bKRVhp9Sqzc0RApOxWYzXUYZjswJ8IMpGUrnhSDTvH576FV8f320ch0Z-oRhgCJ8XplHCZ2kAaXQ_FFo-dV/s1600-h/image%25255B35%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;120&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnUWM7kPCilQDofaUCQ3jj45CJoqJVvE9nT26f4-dcUferNfRambj4gfWTsXzSN-l-dSk0PaZsFotR0P6OlE2DaowezKh3T-EOeAGhLtHZLMS0jiyYtBBAm7cUCXTNqjwFicOiJuf_2W9c/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;244&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 4&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;color: black;&quot;&gt;Saya kurang tahu mengapa situasi tersebut bisa terjadi. Mungkin ada keyboard &lt;i&gt;shortcut&lt;/i&gt; yang menjadikan Workbook Calculation menjadi “Manual” dan teraktifkan secara tidak sengaja.&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;color: black;&quot;&gt;&lt;b&gt;&lt;u&gt;Update 30 Juni 2016&lt;/u&gt;&lt;/b&gt; : Jika ingin solusi lebih cepat, misalnya ingin segera mengetahui perubahan yang disebabkan oleh formula, bisa tekan tombol F9&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://eorenmh.blogspot.com/2013/10/formula-excel-tidak-berfungsi.html&quot;&gt;Sumber&lt;/a&gt;
&lt;br /&gt;
Anda mungkin tertarik untuk membaca ini juga :&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;&lt;a href=&quot;http://www.anuneanu.com/2015/01/cara-crack-password-macro-vba-excel.html&quot; target=&quot;_blank&quot;&gt;Cara Crack Password Macro VBA Excel&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;http://www.anuneanu.com/2018/08/macro-excel-untuk-download-gambar.html&quot; target=&quot;_blank&quot;&gt;Macro VBA Excel untuk Download Gambar Google Maps dan Street View&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/3849550110379010060/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2018/02/mengatasi-rumus-vlookup-tidak-berfungsi.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/3849550110379010060'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/3849550110379010060'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2018/02/mengatasi-rumus-vlookup-tidak-berfungsi.html' title='Mengatasi Rumus VLOOKUP Tidak Berfungsi'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgonbi85dZ0bONMRLXHmjiuVKmw9ByoPxck8nPIbCT2yzZUfU5r_80ghg63qLAFbDjF8xe_r2zBCdEv0lav_DeVp4ZZrLwt3WR3fJvKndGQCn4_Om8HHpMyhHZT1VeaCtVbndIhzUM6X6Yb/s72-c?imgmax=800" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-6662403356191071906</id><published>2018-02-04T22:41:00.001+07:00</published><updated>2018-02-04T22:41:13.484+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="tips n trik Excel"/><title type='text'>Kenapa Rumus VLOOKUP Tidak Berfungsi</title><content type='html'>&lt;span style=&quot;color: black;&quot;&gt;Dalam profesi saya yang sering meng-&lt;i&gt;copy&lt;/i&gt;-&lt;i&gt;paste&lt;/i&gt; banyak formula (misal, VLOOKUP), terkadang saya menemukan situasi dimana formula-formula tersebut sama persis dengan formula sumber nya.&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;596&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXvWZMy9FLaXRoKpmqyfCJCiqu1kXUptH-8eQjpwLVo5YXVw0jAf4676iUgjuqP2sz8ueFzmcyHXVGorJiDaWAyMatbXP8tsb_mZzWHRTtDTuKBvZ37OddnrXvMLPr6P8f2O_P3nE7Tt7D/s1600-h/image%25255B10%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgonbi85dZ0bONMRLXHmjiuVKmw9ByoPxck8nPIbCT2yzZUfU5r_80ghg63qLAFbDjF8xe_r2zBCdEv0lav_DeVp4ZZrLwt3WR3fJvKndGQCn4_Om8HHpMyhHZT1VeaCtVbndIhzUM6X6Yb/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;144&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;596&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 1&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;color: black;&quot;&gt;Pada gambar 1, saya akan meng-&lt;i&gt;copy&lt;/i&gt; formula pada cell B1 ke bawah&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAW79uguCZptWe5FfwiMsSYjY2N2uq_mxI9PdvOIRR7cpkOyhL8QQ_zs2RHgFW3mF_55umnNeq56zWRrZ9pZuxE8uolWQ9oc9Rj7TDAazDQHdA6KVkuX19v9mTBqhs7sbCuDvC4ONVKJnu/s1600-h/image%25255B21%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwyJQAedAm6P58ATA8ZyEVHVd4C2UHF3N30oAaC4UNbQQjdKll0rRz7WSeGbhKU_qT2YnwSo4wr8LcnAdbNWqN2Ddk4gG4XyksIbAUJp0dLgFlnqURShJCt5cwQRRp8ConPTLaaImTnrSg/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;144&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 2&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;Namun terjadilah seperti pada Gambar 2, yaitu formula tidak otomatis ter-&lt;i&gt;update. &lt;/i&gt;Hal ini bisa diatasi dengan cara memilih satu persatu cell, meng-edit-nya (tekan F2) dan Enter (lihat Gambar 3).&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;Namun hal ini tentunya akan sangat melelahkan dan menghabiskan waktu jika kita berurusan dengan ribuan formula, bukan?&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHmafk2cwnGnvtDDDATIPpAX2hWfagQ5cfNHeDpSRaOB4bBOVcrXN71dnqsDg1E-jjCtMV8D1iSp9mjXGLkFP2Vq-jKQQ2RD3kvbaRY98aDMOK7jmE0TUWHy8z07enZOn354JWYJfHXB_q/s1600-h/image%25255B28%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgv9Uwo_NVAxs3viK3gYfOT1j4g9bPeQEae15XpL3UhYOEdqqurl-qxY1Mrk7HtrxR5bOQ5bxrZxpLVmhDt1tV-nyzZD0KW5eqo6V1KMuq1cmE6HhS45SJOysIdtJC4HCh61UQFDatPsFWm/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;144&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 3&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;color: black;&quot;&gt;Setelah &lt;i&gt;googling&lt;/i&gt;, maka saya menemukan bahwa ada opsi di Excel terkait hal ini. Dan ini adalah cara mengatasinya :&lt;/span&gt;&lt;br /&gt;
&lt;ol&gt;
&lt;li&gt;&lt;span style=&quot;color: black;&quot;&gt;Klik “File” lalu klik “Options” &lt;/span&gt; &lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;color: black;&quot;&gt;Klik “Formulas” (pilihan kedua di bawah “General” lalu lihat ke sebelah kanan &lt;/span&gt; &lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;color: black;&quot;&gt;Pastikan “Workbook Calculation” menjadi “Automatic”&lt;/span&gt;&lt;/li&gt;
&lt;/ol&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSYYSXhuKqAEzaviMaqK5Jx0T4rTA75xrSRbmwqdxDjn63D57-3mblvlN81bKRVhp9Sqzc0RApOxWYzXUYZjswJ8IMpGUrnhSDTvH576FV8f320ch0Z-oRhgCJ8XplHCZ2kAaXQ_FFo-dV/s1600-h/image%25255B35%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;120&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnUWM7kPCilQDofaUCQ3jj45CJoqJVvE9nT26f4-dcUferNfRambj4gfWTsXzSN-l-dSk0PaZsFotR0P6OlE2DaowezKh3T-EOeAGhLtHZLMS0jiyYtBBAm7cUCXTNqjwFicOiJuf_2W9c/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;244&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 4&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;color: black;&quot;&gt;Saya kurang tahu mengapa situasi tersebut bisa terjadi. Mungkin ada keyboard &lt;i&gt;shortcut&lt;/i&gt; yang menjadikan Workbook Calculation menjadi “Manual” dan teraktifkan secara tidak sengaja.&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;color: black;&quot;&gt;&lt;b&gt;&lt;u&gt;Update 30 Juni 2016&lt;/u&gt;&lt;/b&gt; : Jika ingin solusi lebih cepat, misalnya ingin segera mengetahui perubahan yang disebabkan oleh formula, bisa tekan tombol F9&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://eorenmh.blogspot.com/2013/10/formula-excel-tidak-berfungsi.html&quot;&gt;Sumber&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/6662403356191071906/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2018/02/kenapa-rumus-vlookup-tidak-berfungsi.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/6662403356191071906'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/6662403356191071906'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2018/02/kenapa-rumus-vlookup-tidak-berfungsi.html' title='Kenapa Rumus VLOOKUP Tidak Berfungsi'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgonbi85dZ0bONMRLXHmjiuVKmw9ByoPxck8nPIbCT2yzZUfU5r_80ghg63qLAFbDjF8xe_r2zBCdEv0lav_DeVp4ZZrLwt3WR3fJvKndGQCn4_Om8HHpMyhHZT1VeaCtVbndIhzUM6X6Yb/s72-c?imgmax=800" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-8039732542141827844</id><published>2018-02-04T22:39:00.002+07:00</published><updated>2018-02-04T22:39:45.581+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="tips n trik Excel"/><title type='text'>Rumus SUM Excel Tidak Berfungsi</title><content type='html'>&lt;span style=&quot;color: black;&quot;&gt;Dalam profesi saya yang sering meng-&lt;i&gt;copy&lt;/i&gt;-&lt;i&gt;paste&lt;/i&gt; banyak formula (misal, VLOOKUP), terkadang saya menemukan situasi dimana formula-formula tersebut sama persis dengan formula sumber nya.&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;596&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXvWZMy9FLaXRoKpmqyfCJCiqu1kXUptH-8eQjpwLVo5YXVw0jAf4676iUgjuqP2sz8ueFzmcyHXVGorJiDaWAyMatbXP8tsb_mZzWHRTtDTuKBvZ37OddnrXvMLPr6P8f2O_P3nE7Tt7D/s1600-h/image%25255B10%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgonbi85dZ0bONMRLXHmjiuVKmw9ByoPxck8nPIbCT2yzZUfU5r_80ghg63qLAFbDjF8xe_r2zBCdEv0lav_DeVp4ZZrLwt3WR3fJvKndGQCn4_Om8HHpMyhHZT1VeaCtVbndIhzUM6X6Yb/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;144&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;596&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 1&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;color: black;&quot;&gt;Pada gambar 1, saya akan meng-&lt;i&gt;copy&lt;/i&gt; formula pada cell B1 ke bawah&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAW79uguCZptWe5FfwiMsSYjY2N2uq_mxI9PdvOIRR7cpkOyhL8QQ_zs2RHgFW3mF_55umnNeq56zWRrZ9pZuxE8uolWQ9oc9Rj7TDAazDQHdA6KVkuX19v9mTBqhs7sbCuDvC4ONVKJnu/s1600-h/image%25255B21%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwyJQAedAm6P58ATA8ZyEVHVd4C2UHF3N30oAaC4UNbQQjdKll0rRz7WSeGbhKU_qT2YnwSo4wr8LcnAdbNWqN2Ddk4gG4XyksIbAUJp0dLgFlnqURShJCt5cwQRRp8ConPTLaaImTnrSg/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;144&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 2&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;Namun terjadilah seperti pada Gambar 2, yaitu formula tidak otomatis ter-&lt;i&gt;update. &lt;/i&gt;Hal ini bisa diatasi dengan cara memilih satu persatu cell, meng-edit-nya (tekan F2) dan Enter (lihat Gambar 3).&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;Namun hal ini tentunya akan sangat melelahkan dan menghabiskan waktu jika kita berurusan dengan ribuan formula, bukan?&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHmafk2cwnGnvtDDDATIPpAX2hWfagQ5cfNHeDpSRaOB4bBOVcrXN71dnqsDg1E-jjCtMV8D1iSp9mjXGLkFP2Vq-jKQQ2RD3kvbaRY98aDMOK7jmE0TUWHy8z07enZOn354JWYJfHXB_q/s1600-h/image%25255B28%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgv9Uwo_NVAxs3viK3gYfOT1j4g9bPeQEae15XpL3UhYOEdqqurl-qxY1Mrk7HtrxR5bOQ5bxrZxpLVmhDt1tV-nyzZD0KW5eqo6V1KMuq1cmE6HhS45SJOysIdtJC4HCh61UQFDatPsFWm/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;144&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 3&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;color: black;&quot;&gt;Setelah &lt;i&gt;googling&lt;/i&gt;, maka saya menemukan bahwa ada opsi di Excel terkait hal ini. Dan ini adalah cara mengatasinya :&lt;/span&gt;&lt;br /&gt;
&lt;ol&gt;
&lt;li&gt;&lt;span style=&quot;color: black;&quot;&gt;Klik “File” lalu klik “Options” &lt;/span&gt; &lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;color: black;&quot;&gt;Klik “Formulas” (pilihan kedua di bawah “General” lalu lihat ke sebelah kanan &lt;/span&gt; &lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;color: black;&quot;&gt;Pastikan “Workbook Calculation” menjadi “Automatic”&lt;/span&gt;&lt;/li&gt;
&lt;/ol&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSYYSXhuKqAEzaviMaqK5Jx0T4rTA75xrSRbmwqdxDjn63D57-3mblvlN81bKRVhp9Sqzc0RApOxWYzXUYZjswJ8IMpGUrnhSDTvH576FV8f320ch0Z-oRhgCJ8XplHCZ2kAaXQ_FFo-dV/s1600-h/image%25255B35%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;120&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnUWM7kPCilQDofaUCQ3jj45CJoqJVvE9nT26f4-dcUferNfRambj4gfWTsXzSN-l-dSk0PaZsFotR0P6OlE2DaowezKh3T-EOeAGhLtHZLMS0jiyYtBBAm7cUCXTNqjwFicOiJuf_2W9c/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;244&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 4&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;color: black;&quot;&gt;Saya kurang tahu mengapa situasi tersebut bisa terjadi. Mungkin ada keyboard &lt;i&gt;shortcut&lt;/i&gt; yang menjadikan Workbook Calculation menjadi “Manual” dan teraktifkan secara tidak sengaja.&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;color: black;&quot;&gt;&lt;b&gt;&lt;u&gt;Update 30 Juni 2016&lt;/u&gt;&lt;/b&gt; : Jika ingin solusi lebih cepat, misalnya ingin segera mengetahui perubahan yang disebabkan oleh formula, bisa tekan tombol F9&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://eorenmh.blogspot.com/2013/10/formula-excel-tidak-berfungsi.html&quot;&gt;Sumber&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/8039732542141827844/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2018/02/rumus-sum-excel-tidak-berfungsi.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/8039732542141827844'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/8039732542141827844'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2018/02/rumus-sum-excel-tidak-berfungsi.html' title='Rumus SUM Excel Tidak Berfungsi'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgonbi85dZ0bONMRLXHmjiuVKmw9ByoPxck8nPIbCT2yzZUfU5r_80ghg63qLAFbDjF8xe_r2zBCdEv0lav_DeVp4ZZrLwt3WR3fJvKndGQCn4_Om8HHpMyhHZT1VeaCtVbndIhzUM6X6Yb/s72-c?imgmax=800" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-6979248410470784320</id><published>2018-02-04T22:38:00.001+07:00</published><updated>2018-02-04T22:38:25.367+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="tips n trik Excel"/><title type='text'>Rumus VLOOKUP Tidak Mau Jalan</title><content type='html'>&lt;span style=&quot;color: black;&quot;&gt;Dalam profesi saya yang sering meng-&lt;i&gt;copy&lt;/i&gt;-&lt;i&gt;paste&lt;/i&gt; banyak formula (misal, VLOOKUP), terkadang saya menemukan situasi dimana formula-formula tersebut sama persis dengan formula sumber nya.&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;596&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXvWZMy9FLaXRoKpmqyfCJCiqu1kXUptH-8eQjpwLVo5YXVw0jAf4676iUgjuqP2sz8ueFzmcyHXVGorJiDaWAyMatbXP8tsb_mZzWHRTtDTuKBvZ37OddnrXvMLPr6P8f2O_P3nE7Tt7D/s1600-h/image%25255B10%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgonbi85dZ0bONMRLXHmjiuVKmw9ByoPxck8nPIbCT2yzZUfU5r_80ghg63qLAFbDjF8xe_r2zBCdEv0lav_DeVp4ZZrLwt3WR3fJvKndGQCn4_Om8HHpMyhHZT1VeaCtVbndIhzUM6X6Yb/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;144&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;596&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 1&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;color: black;&quot;&gt;Pada gambar 1, saya akan meng-&lt;i&gt;copy&lt;/i&gt; formula pada cell B1 ke bawah&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAW79uguCZptWe5FfwiMsSYjY2N2uq_mxI9PdvOIRR7cpkOyhL8QQ_zs2RHgFW3mF_55umnNeq56zWRrZ9pZuxE8uolWQ9oc9Rj7TDAazDQHdA6KVkuX19v9mTBqhs7sbCuDvC4ONVKJnu/s1600-h/image%25255B21%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwyJQAedAm6P58ATA8ZyEVHVd4C2UHF3N30oAaC4UNbQQjdKll0rRz7WSeGbhKU_qT2YnwSo4wr8LcnAdbNWqN2Ddk4gG4XyksIbAUJp0dLgFlnqURShJCt5cwQRRp8ConPTLaaImTnrSg/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;144&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 2&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;Namun terjadilah seperti pada Gambar 2, yaitu formula tidak otomatis ter-&lt;i&gt;update. &lt;/i&gt;Hal ini bisa diatasi dengan cara memilih satu persatu cell, meng-edit-nya (tekan F2) dan Enter (lihat Gambar 3).&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;Namun hal ini tentunya akan sangat melelahkan dan menghabiskan waktu jika kita berurusan dengan ribuan formula, bukan?&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHmafk2cwnGnvtDDDATIPpAX2hWfagQ5cfNHeDpSRaOB4bBOVcrXN71dnqsDg1E-jjCtMV8D1iSp9mjXGLkFP2Vq-jKQQ2RD3kvbaRY98aDMOK7jmE0TUWHy8z07enZOn354JWYJfHXB_q/s1600-h/image%25255B28%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgv9Uwo_NVAxs3viK3gYfOT1j4g9bPeQEae15XpL3UhYOEdqqurl-qxY1Mrk7HtrxR5bOQ5bxrZxpLVmhDt1tV-nyzZD0KW5eqo6V1KMuq1cmE6HhS45SJOysIdtJC4HCh61UQFDatPsFWm/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;144&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 3&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;color: black;&quot;&gt;Setelah &lt;i&gt;googling&lt;/i&gt;, maka saya menemukan bahwa ada opsi di Excel terkait hal ini. Dan ini adalah cara mengatasinya :&lt;/span&gt;&lt;br /&gt;
&lt;ol&gt;
&lt;li&gt;&lt;span style=&quot;color: black;&quot;&gt;Klik “File” lalu klik “Options” &lt;/span&gt; &lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;color: black;&quot;&gt;Klik “Formulas” (pilihan kedua di bawah “General” lalu lihat ke sebelah kanan &lt;/span&gt; &lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;color: black;&quot;&gt;Pastikan “Workbook Calculation” menjadi “Automatic”&lt;/span&gt;&lt;/li&gt;
&lt;/ol&gt;
&lt;br /&gt;
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; style=&quot;width: 600px;&quot;&gt; &lt;tbody&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSYYSXhuKqAEzaviMaqK5Jx0T4rTA75xrSRbmwqdxDjn63D57-3mblvlN81bKRVhp9Sqzc0RApOxWYzXUYZjswJ8IMpGUrnhSDTvH576FV8f320ch0Z-oRhgCJ8XplHCZ2kAaXQ_FFo-dV/s1600-h/image%25255B35%25255D.png&quot;&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;img alt=&quot;image&quot; border=&quot;0&quot; height=&quot;120&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnUWM7kPCilQDofaUCQ3jj45CJoqJVvE9nT26f4-dcUferNfRambj4gfWTsXzSN-l-dSk0PaZsFotR0P6OlE2DaowezKh3T-EOeAGhLtHZLMS0jiyYtBBAm7cUCXTNqjwFicOiJuf_2W9c/?imgmax=800&quot; style=&quot;background-image: none; border-bottom-width: 0px; border-left-width: 0px; border-right-width: 0px; border-top-width: 0px; display: inline; margin: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;&quot; title=&quot;image&quot; width=&quot;244&quot; /&gt;&lt;/span&gt;&lt;/a&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt; &lt;td valign=&quot;top&quot; width=&quot;600&quot;&gt;&lt;div align=&quot;center&quot;&gt;
&lt;span style=&quot;color: black; font-family: &amp;quot;calibri&amp;quot;; font-size: xx-small;&quot;&gt;Gambar 4&lt;/span&gt;&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;color: black;&quot;&gt;Saya kurang tahu mengapa situasi tersebut bisa terjadi. Mungkin ada keyboard &lt;i&gt;shortcut&lt;/i&gt; yang menjadikan Workbook Calculation menjadi “Manual” dan teraktifkan secara tidak sengaja.&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;color: black;&quot;&gt;&lt;b&gt;&lt;u&gt;Update 30 Juni 2016&lt;/u&gt;&lt;/b&gt; : Jika ingin solusi lebih cepat, misalnya ingin segera mengetahui perubahan yang disebabkan oleh formula, bisa tekan tombol F9&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://eorenmh.blogspot.com/2013/10/formula-excel-tidak-berfungsi.html&quot;&gt;Sumber&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/6979248410470784320/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2018/02/rumus-vlookup-tidak-mau-jalan.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/6979248410470784320'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/6979248410470784320'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2018/02/rumus-vlookup-tidak-mau-jalan.html' title='Rumus VLOOKUP Tidak Mau Jalan'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgonbi85dZ0bONMRLXHmjiuVKmw9ByoPxck8nPIbCT2yzZUfU5r_80ghg63qLAFbDjF8xe_r2zBCdEv0lav_DeVp4ZZrLwt3WR3fJvKndGQCn4_Om8HHpMyhHZT1VeaCtVbndIhzUM6X6Yb/s72-c?imgmax=800" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-2960829033167313829</id><published>2016-07-04T05:02:00.001+07:00</published><updated>2016-07-04T05:02:24.681+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="istiqomah"/><category scheme="http://www.blogger.com/atom/ns#" term="thoughts"/><title type='text'>Manusia Yang Berlebih-lebihan</title><content type='html'>Senin, 4 Juli 2016, waktu menunjukkan pukul 4 lebih 38 menit, pagi hari.&lt;br /&gt;
Setelah shalat subuh, tiba-tiba saya memperoleh sebuah pemikiran.&lt;br /&gt;
Mungkin bahasa kerennya adalah &quot;saya telah &lt;i&gt;incepted&lt;/i&gt;&quot;.&lt;br /&gt;
Pemikiran tersebut adalah, terkait dengan kehidupan saya sendiri, bahwa saya telah hidup berlebih-lebihan.&lt;br /&gt;
&lt;br /&gt;
&lt;h4&gt;
Kok gitu?&lt;/h4&gt;
Perhatikan saja beberapa kenyataan berikut ini...&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;1. Nekad beli mobil&lt;/b&gt; dengan mencicil, dengan niat awal untuk membahagiakan keluarga. Terutama istri, yang katanya tiap akhir bulan hampir selalu pulang malam, melalui jalan gelap, demi mengemban amanah pekerjaan. Selain itu, sang istri punya niatan baik untuk nantinya setelah punya mobil akan mau membantu tetangga yang membutuhkan angkutan karena kebutuhan &lt;i&gt;emergency&lt;/i&gt;.&lt;br /&gt;
Mari kita &lt;i&gt;breakdown&lt;/i&gt; kejadian tersebut.&lt;br /&gt;
Beli mobil? OK. Sah sah saja. Namun, metode pembelian via &quot;mencicilnya&quot; itu yang bertentangan dengan aturan agama. Karena melalui pihak ketiga sebagai pembiayaan. Ditambah lagi oleh kenyataan bahwa biaya cicilan tersebut adalah mendekati 33% dari gaji kotor saya, dari pekerjaan yang &lt;b&gt;tidak permanen&lt;/b&gt; ini. Dilihat dari sudut pandang orang ketiga, jelas-jelas ini pemaksaan diri, yaitu hidup berlebih-lebihan.&lt;br /&gt;
&lt;b&gt;Yang seharusnya saya lakukan&lt;/b&gt; : sebenarnya bisa saja, menabung selama beberapa waktu, menggunakan &quot;jatah&quot; uang cicilan tadi, lalu beli mobil bekas yang masih layak pakai.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;2. &quot;Terpaksa&quot; beli motor&lt;/b&gt; dengan (lagi-lagi) mencicil. Yang ini saya beri embel-embel &quot;terpaksa&quot;, karena pada saat itu memang sedang &lt;i&gt;urgent&lt;/i&gt; membutuhkan kendaraan. Sebenarnya sebelumnya saya sudah punya motor, namun karena kebutuhan mendesak, dan saya tidak ingin berhutang, maka saya jual motor nostalgia tersebut (hikz...). Untuk motor ini, alokasi dana nya tidak terlalu besar seperti mobil tersebut. Tapi tetap saja melalui instrumen ribawi.&lt;br /&gt;
&lt;b&gt;Yang seharusnya saya lakukan&lt;/b&gt;&amp;nbsp;: sama saja seperti mobil tersebut. Sebenarnya bisa saja, menabung selama beberapa waktu, menggunakan &quot;jatah&quot; uang cicilan tadi, lalu beli motor bekas yang masih layak pakai.&lt;br /&gt;
&lt;br /&gt;
3. &lt;b&gt;Tidak segera membayar hutang &quot;itu&quot;&lt;/b&gt;. Hutang yang itu memang hutang yang kurang jelas. Karena dibuat pada saat saya masih belum bekerja, masih kuliah, dan ada unsur keterpaksaan di situ. Namun karena saat itu memang &lt;i&gt;urgent&lt;/i&gt;, demi orang tua, maka saya terpaksa menyetujuinya. Sialnya, orang yang menghutangi saya menghilang entah kemana. Nomor hape nya tidak aktif. Sudah saya tunggu hingga bertahun-tahun, dengan cara :&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;saya masih menetap di tempat yang sama, seperti waktu terakhir kali bertemu orang itu&lt;/li&gt;
&lt;li&gt;nomor hape saya masih bertahan cukup lama, terutama karena itu memang nomor operasional dari kantor&lt;/li&gt;
&lt;/ul&gt;
&lt;div&gt;
Namun apa daya, setelah 2 metode ampuh di atas, tetap saja orang itu tidak muncul. Banyak tanya muncul di benak saya, terutama : &lt;b&gt;Apa saya masih wajib membayar hutang tersebut?? Jika iya, saya bayar ke siapa??&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
Kemudian saya mendapat petunjuk dariNya. Saya masih menyimpan nomor rekening orang itu! Maka saya coba memeriksanya, dengan cara mentrasnfer sejumlah kecil uang ke nomor tersebut. Dan ternyata bisa! Dan saya coba verifikasi ke pihak bank, dan memang transaksi tersebut berhasil, menandakan bahwa rekening tersebut masih aktif.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Namun, apa yang justru terjadi? Saya tidak segera membayarnya. Entah karena apa. Mungkin karena pekerjaan. Atau kebutuhan uang yang &quot;mendesak&quot; (lha, tapi kok malah nyicil mobil??)&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;i&gt;Dear&lt;/i&gt; pembaca, cukup dari tiga contoh kejadian nyata di atas. &lt;b&gt;Tiga&lt;/b&gt; itu saja sudah bisa membuat malaikat jengkel terhadap saya. Karena terlibat riba, dan tidak amanah. Apalagi contoh-contoh kejadian nyata lainnya dari episode kehidupan saya.... Yang jelas-jelas mengandung salah satu dosa besar...&lt;/div&gt;
&lt;div&gt;
Karena itulah, terkadang saya maklum jika tiba-tiba mengalami kesulitan hidup. Kesedihan. Kemarahan. Atau bahkan hawa nafsu yang meledak-ledak.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Saya telah hidup berlebih-lebihan. Dilihat dari sudut pandang orang ketiga, yaitu &lt;b&gt;Alloh SWT,&lt;/b&gt; hal itu nampak jelas, sebening embun, sejernih air zam zam.&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/2960829033167313829/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2016/07/manusia-yang-berlebih-lebihan.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/2960829033167313829'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/2960829033167313829'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2016/07/manusia-yang-berlebih-lebihan.html' title='Manusia Yang Berlebih-lebihan'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-1303932486692708543</id><published>2016-06-23T16:28:00.002+07:00</published><updated>2016-06-30T03:48:20.720+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="movie"/><title type='text'>Baca Sinopsis Film Terbaru &quot;Independence Day : Resurgence&quot; di sini !!</title><content type='html'>Awas Spoiler !!&lt;br /&gt;
&lt;br /&gt;
Dua puluh tahun setelah peristiwa dari film pertama, masyarakat internasional pulih dan PBB menciptakan Earth Space Defence (ESD), sebuah program pertahanan global yang bersatu yang berfungsi sebagai sistem peringatan dini bumi. Kekuatan pertahanan utama menggunakan teknologi yang diperoleh dari sisa-sisa pasukan asing, dengan kekuatan militer berkumpul di Bulan, Mars dan Rhea, dan basis Area 51 telah menjadi Space Defence Headquarters.&lt;br /&gt;
&lt;br /&gt;
Di suatu tempat di Afrika, Direktur ESD David Levinson bertemu dengan Dr. Catherine Marceaux dan panglima perang Dikembe Umbutu, yang memimpin mereka ke kapal alien yang masih benar-benar utuh, yang ternyata telah menggali lubang di bawahnya sebelum ditutup setelah induk yang hancur.&lt;br /&gt;
&lt;br /&gt;
Di dalamnya, mereka menemukan bahwa kapal telah mengirimkan panggilan darurat ke planet asalnya. Selanjutnya, Umbutu dan mantan Presiden AS Thomas Whitmore telah memiliki penglihatan imajinasi berulang tentang simbol alien sejak pertemuan pribadi mereka dengan penjajah pada tahun 1996.&lt;br /&gt;
&lt;br /&gt;
Sementara itu, sebuah kapal bola ber-teleport dekat markas pertahanan Bulan ESD ini. Meskipun keraguan Daud bahwa itu adalah berbeda dari penyerbu asing, ESD tetap menyerangnya. Tak peduli akan perintah ESD, pilot Jake Morrison membawa David, Catherine, Umbutu, dan Floyd Rosenberg pada semacam kendaraan angkasa kecil dan menuju lokasi kecelakaan, di mana mereka menemukan sebuah kontainer.&lt;br /&gt;
&lt;br /&gt;
Tiba-tiba, sebuah pesawat induk asing yang jauh lebih besar dari yang sebelumnya pada tahun 1996 muncul dan menghancurkan basis Bulan sebelum mendekati Bumi. Kendaraan lakon kita terperangkap dalam tarikan gravitasi pesawat tersebut, yang sanggup mengangkat bangunan dan struktur dari sebagian besar Asia sebelum dibebaskan atas London, karena panik menghindari hujan puing jatuh sebelum menuju ke Area 51.&lt;br /&gt;
&lt;br /&gt;
Pesawat induk kemudian mendarat di seluruh bagian utara Samudera Atlantik, menghancurkan Washington, DC, dan kota-kota lain dengan kakinya sembari mengebor lubang di tengah laut. Alien juga menyerang bunker Cheyenne di Colorado dan membunuh Presiden Elizabeth Lanford, sehingga membuat Jenderal Joshua Adams sebagai Presiden sementara.&lt;br /&gt;
&lt;br /&gt;
Setelah kedatangan kendaraan lakon kita tadi di Area 51, Dr. Payau Okun bangun dari koma 20 tahun dan membuka kontainer tadi, mengungkapkan sebuah bola putih raksasa yang mengungkapkan ke ESD bahwa ras yang telah berjuang pertempuran kalah dengan pemanen alien selama ribuan tahun dan itu dikirim untuk membantu mengevakuasi sebanyak manusia mungkin ke planet lain untuk melatih mereka melawan alien.&lt;br /&gt;
&lt;br /&gt;
Sementara itu, Thomas memasuki ruang karantina untuk berkomunikasi dengan salah satu alien yang ditaruh di penangkaran sejak perang terakhir. Pasukan ESD dipimpin oleh Kapten. Dylan DuBrow-Hiller melancarkan serangan balik, tapi terjebak dalam perangkap dalam induk tersebut.&lt;br /&gt;
Dylan, bersama dengan Jake, Letnan Ritter, dan Rain Lao, berhasil keluar dari pesawat mereka dan melarikan diri menggunakan dua unit tempur alien.&lt;br /&gt;
&lt;br /&gt;
Namun hal tersebut diketahui oleh ratu alien , maka pasukan ESD yang tersisa menggunakan kendaraan kecil tadi dengan kontainer kosong sebagai umpan untuk memikat kapal ratu alien untuk daerah terpencil dan menghancurkannya dengan bom reaktor fusi dingin.&lt;br /&gt;
&lt;br /&gt;
Tanpa menghiraukan keinginan Patricia, Thomas merelakan diri untuk mengendarai kendaraan kecil tsb sebagai misi bunuh diri.&lt;br /&gt;
&lt;br /&gt;
Selama pertempuran dekat Area 51, Thomas memimpin kapal ratu alien untuk perangkap dan meledakan bom, membunuh dia dan menghancurkan kapal. Namun, ratu alien muncul dari reruntuhan, memiliki perisai energi yang diaktifkan pada exoskeleton nya.&lt;br /&gt;
&lt;br /&gt;
Dia menuju Area 51, tapi Dylan, Jake, Ritter, dan Rain menembak ke bawah dengan kapal tempur asing mereka sebelum ia mendapat kesempatan untuk menghancurkan bola. Sang Ratu pun tewas, pesawat induk menghentikan pengeboran menuju inti bumi dan mundur ke ruang angkasa.&lt;br /&gt;
&lt;br /&gt;
Dr. Okun mengungkapkan bahwa bola telah mengatakan kepadanya bagaimana ia terkesan akan ketahanan dan perjuangan manusia, dan menawarkan untuk memberikan teknologi yang cukup untuk mengikuti pertempuran di dunia alien&lt;br /&gt;
&lt;br /&gt;
Sumber : Wikipedia</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/1303932486692708543/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2016/06/baca-sinopsis-film-terbaru-independence.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/1303932486692708543'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/1303932486692708543'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2016/06/baca-sinopsis-film-terbaru-independence.html' title='Baca Sinopsis Film Terbaru &quot;Independence Day : Resurgence&quot; di sini !!'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-1934648810130180246</id><published>2016-06-23T16:13:00.001+07:00</published><updated>2016-06-30T03:49:00.076+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="sepakbola"/><title type='text'>Lihat Jadwal dan Skema Babak 16 Besar Piala Eropa 2016 !!</title><content type='html'>&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkAW-CWE0eLclxbd0qKUdZZtVOVDFQUcroxCg9kbKHKBpBoSin_7GG_qoOUtHPFQE99IrFdgj87htEYzOVWT31xkvb6fPD-SQUiz-hprunxFJNtgXfqO8xTjFsLu5YOL0q5vg_0suTa3dC/s1600/jadwal+euro+2016.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkAW-CWE0eLclxbd0qKUdZZtVOVDFQUcroxCg9kbKHKBpBoSin_7GG_qoOUtHPFQE99IrFdgj87htEYzOVWT31xkvb6fPD-SQUiz-hprunxFJNtgXfqO8xTjFsLu5YOL0q5vg_0suTa3dC/s1600/jadwal+euro+2016.png&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
Dari Juara.net</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/1934648810130180246/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2016/06/lihat-jadwal-dan-skema-babak-16-besar.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/1934648810130180246'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/1934648810130180246'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2016/06/lihat-jadwal-dan-skema-babak-16-besar.html' title='Lihat Jadwal dan Skema Babak 16 Besar Piala Eropa 2016 !!'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkAW-CWE0eLclxbd0qKUdZZtVOVDFQUcroxCg9kbKHKBpBoSin_7GG_qoOUtHPFQE99IrFdgj87htEYzOVWT31xkvb6fPD-SQUiz-hprunxFJNtgXfqO8xTjFsLu5YOL0q5vg_0suTa3dC/s72-c/jadwal+euro+2016.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-6742951548192440258</id><published>2016-06-23T16:09:00.001+07:00</published><updated>2016-06-30T03:48:51.625+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="berita"/><title type='text'>Mau Motor Ninja? Mainkan Game di UC Browser !!</title><content type='html'>&lt;h1 class=&quot;entry-title&quot;&gt;
&lt;span style=&quot;font-weight: normal;&quot;&gt;&lt;span style=&quot;font-family: Times, Times New Roman, serif; font-size: small;&quot;&gt;Memasuki minggu ke-tiga Ramadhan, UC Browser membuat kampanye terbaru &quot;UC Browser Ramadhan&quot;, atau #UCBrowserRamadhan di social media sejak 21 Juni hingga 27 Juni.&lt;/span&gt;&lt;/span&gt;&lt;/h1&gt;
&lt;div&gt;
Setiap pengguna dapat memainkan game interaktif &quot;Tukar 5 kartu, Dengan Motor Ninja&quot;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Untuk memperoleh kartu, pengguna hanya perlu men-share game dengan teman-teman mereka di Facebook. Pengguna yang berhasil mengumpulkan 5 kartu akan memperoleh hadiah spesial berupa motor Ninja terbaru.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Selain hadiah utama motor Ninja tersebut, pengguna yang memesan barang di Lazada melalui UC Browser pada periode 21 Juni hingga 27 Juni akan memperoleh peluang untuk memenangkan kontes &quot;UC Browser Celeb Courier&quot;.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Hadiahnya, mereka akan berjumpa dengan idola favorit yang akan menjadi kurir, yaitu Raffi Ahmad, Prilly Latuconsina, dan Cassandra Lee.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/6742951548192440258/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2016/06/mau-motor-ninja-mainkan-game-di-uc.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/6742951548192440258'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/6742951548192440258'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2016/06/mau-motor-ninja-mainkan-game-di-uc.html' title='Mau Motor Ninja? Mainkan Game di UC Browser !!'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-7281552641469864186</id><published>2016-06-23T04:48:00.001+07:00</published><updated>2016-06-23T04:48:23.336+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="adsense"/><category scheme="http://www.blogger.com/atom/ns#" term="google"/><title type='text'>Bolehkah Memasang Iklan Google Adsense Punya Orang Lain</title><content type='html'>dari : http://maringenet.blogspot.co.id/2012/08/memasang-iklan-google-adsense-punya-orang-lain.html&lt;br /&gt;
&lt;br /&gt;
&lt;div style=&quot;background-color: white; border: 0px; color: #444444; font-family: &amp;quot;Open Sans&amp;quot;; font-size: 14px; font-stretch: inherit; line-height: 22.4px; margin: 0px; padding: 0px; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;b style=&quot;border: 0px; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; transition: color 0.2s; vertical-align: baseline;&quot;&gt;Memasang Iklan Google Adsense Punya Orang Lain&lt;/b&gt;. Artikel ini diilhami oleh sebuah pertanyaan di Yahoo! Answer. Penanya mengaku begitu sulit mendaftar di Google Adsense. Jika boleh memasang adsense milik orang lain, dia mau melakukannya.&lt;/div&gt;
&lt;div style=&quot;background-color: white; border: 0px; color: #444444; font-family: &amp;quot;Open Sans&amp;quot;; font-size: 14px; font-stretch: inherit; line-height: 22.4px; margin: 0px; padding: 0px; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;br style=&quot;margin: 0px; padding: 0px;&quot; /&gt;&lt;/div&gt;
&lt;div style=&quot;background-color: white; border: 0px; color: #444444; font-family: &amp;quot;Open Sans&amp;quot;; font-size: 14px; font-stretch: inherit; line-height: 22.4px; margin: 0px; padding: 0px; text-align: justify; vertical-align: baseline;&quot;&gt;
Pertanyaannya:&lt;/div&gt;
&lt;div style=&quot;background-color: white; border: 0px; color: #444444; font-family: &amp;quot;Open Sans&amp;quot;; font-size: 14px; font-stretch: inherit; line-height: 22.4px; margin: 0px; padding: 0px; text-align: justify; vertical-align: baseline;&quot;&gt;
Bolehkan memasang iklan Google Adsense di blog kita yang akun adsensenya dimiliki orang lain?&lt;/div&gt;
&lt;div style=&quot;background-color: white; border: 0px; color: #444444; font-family: &amp;quot;Open Sans&amp;quot;; font-size: 14px; font-stretch: inherit; line-height: 22.4px; margin: 0px; padding: 0px; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;br style=&quot;margin: 0px; padding: 0px;&quot; /&gt;&lt;/div&gt;
&lt;div style=&quot;background-color: white; border: 0px; color: #444444; font-family: &amp;quot;Open Sans&amp;quot;; font-size: 14px; font-stretch: inherit; line-height: 22.4px; margin: 0px; padding: 0px; text-align: justify; vertical-align: baseline;&quot;&gt;
Jawabannya:&lt;/div&gt;
&lt;div style=&quot;background-color: white; border: 0px; color: #444444; font-family: &amp;quot;Open Sans&amp;quot;; font-size: 14px; font-stretch: inherit; line-height: 22.4px; margin: 0px; padding: 0px; text-align: justify; vertical-align: baseline;&quot;&gt;
Boleh.&lt;/div&gt;
&lt;div style=&quot;background-color: white; border: 0px; color: #444444; font-family: &amp;quot;Open Sans&amp;quot;; font-size: 14px; font-stretch: inherit; line-height: 22.4px; margin: 0px; padding: 0px; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;br style=&quot;margin: 0px; padding: 0px;&quot; /&gt;&lt;/div&gt;
&lt;div style=&quot;background-color: white; border: 0px; color: #444444; font-family: &amp;quot;Open Sans&amp;quot;; font-size: 14px; font-stretch: inherit; line-height: 22.4px; margin: 0px; padding: 0px; text-align: justify; vertical-align: baseline;&quot;&gt;
Setahu saya Google tidak melarang pemilik akun adsense untuk menambahkan website baru bagi akun adsensenya selama website / blog tersebut mematuhi aturan Google adsense. Jadi dia bisa memasang iklan adsensenya di website mana pun selama yang punya website bersedia untuk memasang iklan adsense dari orang tersebut.&lt;/div&gt;
&lt;div style=&quot;background-color: white; border: 0px; color: #444444; font-family: &amp;quot;Open Sans&amp;quot;; font-size: 14px; font-stretch: inherit; line-height: 22.4px; margin: 0px; padding: 0px; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;background-color: white; border: 0px; color: #444444; font-family: &amp;quot;Open Sans&amp;quot;; font-size: 14px; font-stretch: inherit; line-height: 22.4px; margin: 0px; padding: 0px; text-align: justify; vertical-align: baseline;&quot;&gt;
Maka, berdasarkan informasi pada website tersebut, mulai hari ini saya akan memasang adsense milik teman saya yang sudah di-approve oleh Google. Karena, sebelum sebelumnya saya selalu gagal dalam proses verifikasi Adsense&lt;/div&gt;
&lt;div style=&quot;background-color: white; border: 0px; color: #444444; font-family: &amp;quot;Open Sans&amp;quot;; font-size: 14px; font-stretch: inherit; line-height: 22.4px; margin: 0px; padding: 0px; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;background-color: white; border: 0px; color: #444444; font-family: &amp;quot;Open Sans&amp;quot;; font-size: 14px; font-stretch: inherit; line-height: 22.4px; margin: 0px; padding: 0px; text-align: justify; vertical-align: baseline;&quot;&gt;
Selengkapnya ada juga di sini :&amp;nbsp;&lt;span style=&quot;line-height: 22.4px;&quot;&gt;https://support.google.com/adsense/bin/answer.py?hl=id&amp;amp;answer=1346295&amp;amp;topic=1271508&amp;amp;rd=1#Ads_on_the_same_page_or_site_as_another_publisher&lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/7281552641469864186/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2016/06/bolehkah-memasang-iklan-google-adsense.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/7281552641469864186'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/7281552641469864186'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2016/06/bolehkah-memasang-iklan-google-adsense.html' title='Bolehkah Memasang Iklan Google Adsense Punya Orang Lain'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-3276221034673926504</id><published>2015-12-30T18:05:00.001+07:00</published><updated>2015-12-30T18:05:44.280+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="youtube"/><title type='text'>Cara Melepaskan Diri Dari Atasan #1 Pura-Pura Laptop Ngehang</title><content type='html'>&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;iframe width=&quot;320&quot; height=&quot;266&quot; class=&quot;YOUTUBE-iframe-video&quot; data-thumbnail-src=&quot;https://i.ytimg.com/vi/JV-d1tl0OUs/0.jpg&quot; src=&quot;https://www.youtube.com/embed/JV-d1tl0OUs?feature=player_embedded&quot; frameborder=&quot;0&quot; allowfullscreen&gt;&lt;/iframe&gt;&lt;/div&gt;
&lt;br /&gt;</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/3276221034673926504/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2015/12/cara-melepaskan-diri-dari-atasan-1-pura.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/3276221034673926504'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/3276221034673926504'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2015/12/cara-melepaskan-diri-dari-atasan-1-pura.html' title='Cara Melepaskan Diri Dari Atasan #1 Pura-Pura Laptop Ngehang'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://img.youtube.com/vi/JV-d1tl0OUs/default.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-340641916324512013</id><published>2015-03-23T09:41:00.003+07:00</published><updated>2016-06-30T03:49:41.161+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="tips"/><title type='text'>Memata-matai laptop istri</title><content type='html'>Lengkapnya di sini&lt;br /&gt;
&lt;a href=&quot;http://nostalgilaku.blogspot.com/2015/03/memata-matai-laptop-istri.html&quot;&gt;http://nostalgilaku.blogspot.com/2015/03/memata-matai-laptop-istri.html&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/340641916324512013/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2015/03/memata-matai-laptop-istri.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/340641916324512013'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/340641916324512013'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2015/03/memata-matai-laptop-istri.html' title='Memata-matai laptop istri'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-5679976524651096165</id><published>2015-03-22T00:34:00.002+07:00</published><updated>2016-06-30T03:49:52.123+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="android"/><category scheme="http://www.blogger.com/atom/ns#" term="tips"/><title type='text'>hape android bisa wifi tapi tidak bisa seluler</title><content type='html'>&lt;a href=&quot;http://nostalgilaku.blogspot.com/2015/03/hape-android-bisa-wifi-tapi-tidak-bisa.html&quot;&gt;http://nostalgilaku.blogspot.com/2015/03/hape-android-bisa-wifi-tapi-tidak-bisa.html&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/5679976524651096165/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2015/03/hape-android-bisa-wifi-tapi-tidak-bisa.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/5679976524651096165'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/5679976524651096165'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2015/03/hape-android-bisa-wifi-tapi-tidak-bisa.html' title='hape android bisa wifi tapi tidak bisa seluler'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-2293334389810688500</id><published>2015-03-21T20:59:00.001+07:00</published><updated>2016-06-30T03:49:41.158+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="tips"/><title type='text'>Worms World Party Compatibility Fix Windows 8 Pro 64 bit</title><content type='html'>&lt;a href=&quot;http://nostalgilaku.blogspot.com/2015/03/worms-world-party-compatibility-fix-windows-8-84-bit.html&quot;&gt;http://nostalgilaku.blogspot.com/2015/03/worms-world-party-compatibility-fix-windows-8-84-bit.html&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/2293334389810688500/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2015/03/worms-world-party-compatibility-fix.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/2293334389810688500'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/2293334389810688500'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2015/03/worms-world-party-compatibility-fix.html' title='Worms World Party Compatibility Fix Windows 8 Pro 64 bit'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-4105460085094984435</id><published>2014-12-02T07:51:00.002+07:00</published><updated>2014-12-02T07:51:22.460+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="teespring"/><title type='text'>Teespring : Do Not Feed The Sorrow</title><content type='html'>Hey, check my latest design here :&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://teespring.com/donotfeedthesorrow&quot;&gt;http://teespring.com/donotfeedthesorrow&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
Thanks!</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/4105460085094984435/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2014/12/teespring-do-not-feed-sorrow.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/4105460085094984435'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/4105460085094984435'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2014/12/teespring-do-not-feed-sorrow.html' title='Teespring : Do Not Feed The Sorrow'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-6399181925828368562</id><published>2014-12-01T23:18:00.004+07:00</published><updated>2014-12-01T23:18:44.105+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="teespring"/><title type='text'>Teespring : Feed Me With Love</title><content type='html'>Hey, check my (very very super duper simple) design here!&lt;br /&gt;
&lt;a href=&quot;http://teespring.com/feed_me_with_love&quot;&gt;http://teespring.com/feed_me_with_love&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/6399181925828368562/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2014/12/teespring-feed-me-with-love.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/6399181925828368562'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/6399181925828368562'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2014/12/teespring-feed-me-with-love.html' title='Teespring : Feed Me With Love'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-5418998307702341795</id><published>2014-11-16T06:29:00.003+07:00</published><updated>2014-11-16T06:29:37.076+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="android"/><title type='text'>Android Auto-Sync Turned off</title><content type='html'>Di Advan S5e yang saya pakai, Jelly Bean 4.2.2&lt;br /&gt;
Kok di semua akun, auto-sync nya off? Ga ada centang2 seperti biasanya&lt;br /&gt;
Ternyata, solusinya ada di Data Usage&amp;gt;Menu&amp;gt;Auto-Sync Data&lt;br /&gt;
Jadi, masuk ke &quot;Data Usage&quot;, lalu klik tombol &quot;Menu&quot;, maka ada pilihan &quot;Auto-Sync Data&quot; di situ&lt;br /&gt;
Centang saja&lt;br /&gt;
Lalu balik ke setting Accounts, maka centang auto-sync akan muncul seperti biasanya </content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/5418998307702341795/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2014/11/android-auto-sync-turned-off.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/5418998307702341795'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/5418998307702341795'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2014/11/android-auto-sync-turned-off.html' title='Android Auto-Sync Turned off'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-2163211450068855547</id><published>2014-08-07T02:50:00.003+07:00</published><updated>2014-08-07T02:50:36.266+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="blade"/><title type='text'>farewell, my beloved blade (*sob*)</title><content type='html'>tak dinyana, hari ini, 2014 08 07 (katanya) blade ku bakal resmi dijual, kepada salah seorang warga Tulungagung, yang katanya kenal juga oleh ibuk...&lt;br /&gt;
&lt;br /&gt;
setelah sekian lama, sejak akhir 2008 setia menemaniku, kini, dikau pergi duhai Blade&lt;br /&gt;
&lt;br /&gt;
bukan aku hendak memuja benda duniawi, namun aku hanyalah manusia biasa dengan segala kenangan di kepala&lt;br /&gt;
&lt;br /&gt;
walau terjual murah, karena kepepet hutang, namun sungguh nilai mu sangat besar di hatiku duhai Blade...&lt;br /&gt;
&lt;br /&gt;
(rodo nyesel lan kecewa sich, mending tak jarno ae dekne nang Sby, tapi nang Sby yo ga ono uwong sing iso dipercoyo sich, gara2 project kukut)&lt;br /&gt;
&lt;br /&gt;
list kenangans (gak urut) :&lt;br /&gt;
1. nggonceng ibuk, terutama memory pas banjir nang ubaya, seems just like yesterday&lt;br /&gt;
kedua, sing pas tak &quot;tinggal&quot; nang omahe bu sur bengi2 kae&lt;br /&gt;2. nggonceng bapak, terutama memory nang peneleh&lt;br /&gt;
kedua, sing pas perbarui plat nang samsat &lt;br /&gt;
3. nggonceng nofi, awal2 ketemu (kedua sich sakjane)&lt;br /&gt;
4. nggonceng fitria, pas nang TA&lt;br /&gt;
5. nekad motoran bengi2 nang klakah, lan juga sebaliknya&lt;br /&gt;
6. boncengan karo hermawan nang malang, lan juga nang batu&lt;br /&gt;
7. Blade nginep nang bungur, L6145P&lt;br /&gt;
8. Blade dirubung semut &lt;br /&gt;
9. parkir nang TP, elektro, pesatnet kenjeran, gembong, ITC (tragedi semut pertama kali), pasar atom...&lt;br /&gt;
&lt;br /&gt;dan lain2nya yang saat ini ditulis, enggan muncul di permukaan, layaknya putri malu&lt;br /&gt;
&lt;br /&gt;
hikz hikz hikz...&lt;br /&gt;
&lt;br /&gt;
farewell, duhai my beloved Blade...</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/2163211450068855547/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2014/08/farewell-my-beloved-blade-sob.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/2163211450068855547'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/2163211450068855547'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2014/08/farewell-my-beloved-blade-sob.html' title='farewell, my beloved blade (*sob*)'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-3573698824475358540</id><published>2014-05-24T14:51:00.002+07:00</published><updated>2016-06-30T03:50:26.158+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="tips"/><category scheme="http://www.blogger.com/atom/ns#" term="windows"/><title type='text'>XAMPP mysqld.exe high memory usage</title><content type='html'>i found recently that mysqld.exe on my XAMPP system is having high memory usage around 450 MB. And it just steadily sit there all the time.&lt;br /&gt;
After a brief googling, i found this solution, to set&amp;nbsp;&lt;span style=&quot;background-color: #f3f3f3; color: #222222; font-family: &#39;Droid Sans Mono&#39;, Consolas, Menlo, Monaco, &#39;Lucida Console&#39;, &#39;Liberation Mono&#39;, &#39;DejaVu Sans Mono&#39;, &#39;Bitstream Vera Sans Mono&#39;, &#39;Courier New&#39;, monospace, serif; font-size: 12px; line-height: 17px; white-space: pre-wrap;&quot;&gt;performance_schema = off&lt;/span&gt;&lt;br /&gt;
inside my.ini (C:\xampp\mysql\bin folder)&lt;br /&gt;
Afterwards, the mem usage become around 250 MB.&lt;br /&gt;
&lt;br /&gt;
I dont have time to learn what the actual effect of that setting, so i&#39;ll just leave it like that for the sake of convenience</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/3573698824475358540/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2014/05/xampp-mysqldexe-high-memory-usage.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/3573698824475358540'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/3573698824475358540'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2014/05/xampp-mysqldexe-high-memory-usage.html' title='XAMPP mysqld.exe high memory usage'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-6072105272232466692</id><published>2014-04-22T07:48:00.001+07:00</published><updated>2016-06-30T03:50:26.160+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="tips"/><category scheme="http://www.blogger.com/atom/ns#" term="windows"/><title type='text'>Windows 8 Store tidak berfungsi</title><content type='html'>Pernahkah anda mengklik &quot;Store&quot; pada Windows 8, lalu tampilan hijau itu muncul namun hanya sebentar?&lt;br /&gt;
Well, saya mengalaminya. Lalu setelah melihat error pada event viewer, nampak error sbb :&lt;br /&gt;
&lt;br /&gt;
Activation of app winstore_cw5n1h2txyewy!Windows.Store failed with error: The system cannot find the file specified. See the Microsoft-Windows-TWinUI/Operational log for additional information.&lt;br /&gt;
&lt;br /&gt;
Maka saya coba googling, dan setelah beberapa kali mencoba beberapa solusi, saya berhasil membuka aplikasi Store dengan solusi ini :&lt;br /&gt;
&lt;br /&gt;
powershell -ExecutionPolicy Unrestricted Add-AppxPackage -DisableDevelopmentMode -Register $Env:SystemRoot\WinStore\AppxManifest.xml&lt;br /&gt;
&lt;br /&gt;
jalankan perintah tsb di command prompt, dengan elevasi Administrator.&lt;br /&gt;
Sebelumnya, dia sempat error, dengan muncul tulisan merah, namun setelah saya restart windows (biasanya saya hibernate, JARANG restart), dan saya coba lagi, maka command tsb berhasil, dan saya bisa membuka aplikasi Store&lt;br /&gt;
&lt;br /&gt;
Sumber : http://social.technet.microsoft.com/Forums/windows/en-US/68f0297a-f79b-4a17-8011-af49b049a57e/store-app-does-not-start</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/6072105272232466692/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2014/04/windows-8-store-tidak-berfungsi.html#comment-form' title='0 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/6072105272232466692'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/6072105272232466692'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2014/04/windows-8-store-tidak-berfungsi.html' title='Windows 8 Store tidak berfungsi'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-7241470904841227586.post-6955028251483937261</id><published>2013-10-30T17:52:00.000+07:00</published><updated>2013-10-30T17:52:10.292+07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="windows"/><title type='text'>Membersihkan File Windows Update pada Windows 8</title><content type='html'>Biasanya, windows masih menyisakan &lt;i&gt;file-file&lt;/i&gt; sisa Windows Update. Dan mereka berukuran hingga ratusan MB. Karena &lt;i&gt;drive&lt;/i&gt; C saya hanya berukuran 60 GB dan sangat rentan akan &quot;&lt;i&gt;low disk space&lt;/i&gt;&quot;, maka saya kelabakan ketika hari ini saya mendapati &lt;i&gt;free space&lt;/i&gt; hanya sekitar 30 MB di &lt;i&gt;Drive&lt;/i&gt; C.&lt;br /&gt;
&lt;br /&gt;
Setelah &lt;i&gt;googling&lt;/i&gt;, maka saya menemukan lokasi &lt;i&gt;file-file&lt;/i&gt; tersebut, dan ternyata bisa dengan mudah dihapus.&lt;br /&gt;
&lt;br /&gt;
Buka &lt;i&gt;folder&lt;/i&gt; C:\Windows\SoftwareDistribution, lalu buka &lt;i&gt;folder&lt;/i&gt; DataStore, dan hapus semua yang ada di dalamnya (anda mungkin akan membutuhkan ijin akses Administrator untuk ini). Lalu, balik satu tingkat ke atas, dan buka &lt;i&gt;folder&lt;/i&gt; Download, dan hapus semua yang ada di dalamnya.&lt;br /&gt;
&lt;br /&gt;
Sudah, begitu saja caranya, mudah bukan?&lt;br /&gt;
Metode tersebut sebenarnya untuk WIndows 7, namun saya mencobanya pada Windows 8 dan bisa.</content><link rel='replies' type='application/atom+xml' href='http://eorenmh.blogspot.com/feeds/6955028251483937261/comments/default' title='Posting Komentar'/><link rel='replies' type='text/html' href='http://eorenmh.blogspot.com/2013/10/membersihkan-file-windows-update-pada.html#comment-form' title='2 Komentar'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/6955028251483937261'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/7241470904841227586/posts/default/6955028251483937261'/><link rel='alternate' type='text/html' href='http://eorenmh.blogspot.com/2013/10/membersihkan-file-windows-update-pada.html' title='Membersihkan File Windows Update pada Windows 8'/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:total>2</thr:total></entry></feed>