{"id":2171,"date":"2023-09-26T08:17:01","date_gmt":"2023-09-26T08:17:01","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/"},"modified":"2023-12-06T06:18:59","modified_gmt":"2023-12-06T06:18:59","slug":"menyegarkan-semuanya","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/","title":{"rendered":"Bagaimana cara menyegarkan semua tabel pivot?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3919233302\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Percayalah, jika Anda bisa menyegarkan semua tabel pivot secara bersamaan, Anda bisa menghemat banyak waktu. Ya itu benar. Berpikirlah seperti ini. Anda memiliki 10 tabel pivot dan untuk menyegarkan satu tabel pivot diperlukan waktu beberapa detik.<\/p><p> <strong>10 pivot = 10 detik<\/strong><\/p><p> Sama seperti Anda dapat mengotomatiskan <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/tabel-pivot-1\/\" data-wpel-link=\"internal\" data-wpil=\"url\">pembuatan tabel pivot,<\/a> ada beberapa cara yang dapat Anda gunakan untuk menyegarkannya secara otomatis. Pada artikel ini, saya akan berbagi dengan Anda 3 metode sederhana yang dapat Anda gunakan untuk menyegarkan semua tabel pivot dan waktu Anda.<\/p><h2 class=\"wp-block-heading\"> Gunakan tombol \u201cRefresh Semua\u201d untuk memperbarui semua tabel pivot di buku kerja<\/h2><p> Tombol \u201cRefresh Semua\u201d adalah cara sederhana dan mudah untuk menyegarkan semua tabel pivot di buku kerja dengan satu klik. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Actualiser-manuellement-tous-les-tableaux-croises-dynamiques-en-un-seul-clic.png\" sizes=\"\" srcset=\"\" alt=\"Segarkan semua tabel pivot secara manual dengan satu klik\"><\/figure><\/div><p> Yang perlu Anda lakukan hanyalah masuk ke tab Data \u279c Koneksi \u279c Refresh Semua.<\/p><h2 id=\"tab-con-2\" class=\"wp-block-heading\"> Refresh semua pivot secara otomatis saat Anda membuka buku kerja<\/h2><p> Jika Anda ingin me-refresh semua tabel pivot saat membuka buku kerja, Anda bisa menggunakan langkah-langkah berikut untuk melakukan pengaturan satu kali untuk ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Actualiser-tous-les-tableaux-croises-dynamiques-a-louverture-dun-fichier-1.png\" sizes=\"\" srcset=\"\" alt=\"Refresh semua tabel pivot saat membuka file\"><\/figure><\/div><p> Berikut adalah langkah-langkah yang bisa Anda gunakan untuk me-refresh semua tabel pivot secara otomatis saat membuka buku kerja.<\/p><ol><li> Pilih salah satu tabel pivot di buku kerja Anda.<\/li><li> Klik kanan padanya dan pilih &#8220;Opsi Tabel Pivot&#8221;.<\/li><li> Buka tab Data \u279c Centang \u201cRefresh data saat membuka file\u201d.<\/li><li> Klik Oke.<\/li><\/ol><h2 class=\"wp-block-heading\"> Kode VBA untuk memperbarui semua tabel pivot dalam satu klik<\/h2><p> Ya, Anda juga dapat menggunakan VBA untuk menyegarkan semua tabel pivot. Yang perlu Anda lakukan hanyalah menggunakan kode yang disebutkan di bawah ini.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub RefreshCustomPivotTable() With ActiveSheet .PivotTables.RefreshTable End With End Sub<\/code><\/pre><p> Kode di atas akan menyegarkan semua tabel pivot di lembar kerja aktif Anda dan Anda juga bisa menetapkan makro ini ke tombol untuk digunakan dengan satu klik.<\/p><h3 class=\"wp-block-heading\"> Segarkan hanya tabel pivot tertentu dengan VBA<\/h3><p> Jika Anda memiliki tabel pivot tertentu yang ingin Anda perbarui, Anda dapat menggunakan kode VBA di bawah ini.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub RefreshCustomPivotTable() With ActiveSheet .PivotTables(\"PivotTable1\").RefreshTable .PivotTables(\"PivotTable2\").RefreshTable .PivotTables(\"PivotTable3\").RefreshTable .PivotTables(\"PivotTable4\").RefreshTable .PivotTables(\"PivotTable5\").RefreshTable End With End Sub<\/code><\/pre><p> Ubah nama tabel pivot sesuai dengan buku kerja Anda. Dan, jika Anda ingin memperbarui tabel pivot kustom ini setiap kali Anda membuka buku kerja, ubah nama makro menjadi <a href=\"https:\/\/support.office.com\/en-us\/article\/Automatically-run-a-macro-when-opening-a-workbook-1e55959b-e077-4c88-a696-c3017600db44\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">auto_open<\/a> .<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub auto_open() With ActiveSheet .PivotTables(\"PivotTable1\").RefreshTable .PivotTables(\"PivotTable2\").RefreshTable .PivotTables(\"PivotTable3\").RefreshTable .PivotTables(\"PivotTable4\").RefreshTable .PivotTables(\"PivotTable5\").RefreshTable End With End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Pelajari lebih lanjut tentang tabel pivot<\/h2><ol><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/menghubungkan-alat-pengiris-ke-beberapa-tabel-pivot\/\" data-wpel-link=\"internal\">Hubungkan satu segmen dengan beberapa tabel pivot<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/menghubungkan-alat-pengiris-ke-beberapa-tabel-pivot\/\" data-wpel-link=\"internal\">Perbarui rentang tabel pivot secara otomatis<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/tanggal-grup\/\" data-wpel-link=\"internal\">Kelompokkan tanggal dalam tabel pivot<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/filter-garis-waktu\/\" data-wpel-link=\"internal\">Garis Waktu Tabel Pivot<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/tabel-dinamis-mereferensikan-silang-beberapa-file\/\" data-wpel-link=\"internal\">Tabel pivot menggunakan banyak file<\/a><\/li><\/ol>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2171","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara menyegarkan semua tabel pivot?<\/title>\n<meta name=\"description\" content=\"Untuk menyegarkan semua tabel pivot sekaligus, Anda dapat menggunakan VBA, tombol segarkan, atau opsi tabel\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menyegarkan semua tabel pivot?\" \/>\n<meta property=\"og:description\" content=\"Untuk menyegarkan semua tabel pivot sekaligus, Anda dapat menggunakan VBA, tombol segarkan, atau opsi tabel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Actualiser-manuellement-tous-les-tableaux-croises-dynamiques-en-un-seul-clic.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/\",\"name\":\"Bagaimana cara menyegarkan semua tabel pivot?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Actualiser-manuellement-tous-les-tableaux-croises-dynamiques-en-un-seul-clic.png\",\"datePublished\":\"2023-09-26T08:17:01+00:00\",\"dateModified\":\"2023-12-06T06:18:59+00:00\",\"description\":\"Untuk menyegarkan semua tabel pivot sekaligus, Anda dapat menggunakan VBA, tombol segarkan, atau opsi tabel\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Actualiser-manuellement-tous-les-tableaux-croises-dynamiques-en-un-seul-clic.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Actualiser-manuellement-tous-les-tableaux-croises-dynamiques-en-un-seul-clic.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menyegarkan semua tabel pivot?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara menyegarkan semua tabel pivot?","description":"Untuk menyegarkan semua tabel pivot sekaligus, Anda dapat menggunakan VBA, tombol segarkan, atau opsi tabel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menyegarkan semua tabel pivot?","og_description":"Untuk menyegarkan semua tabel pivot sekaligus, Anda dapat menggunakan VBA, tombol segarkan, atau opsi tabel","og_url":"https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:59+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Actualiser-manuellement-tous-les-tableaux-croises-dynamiques-en-un-seul-clic.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/","url":"https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/","name":"Bagaimana cara menyegarkan semua tabel pivot?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Actualiser-manuellement-tous-les-tableaux-croises-dynamiques-en-un-seul-clic.png","datePublished":"2023-09-26T08:17:01+00:00","dateModified":"2023-12-06T06:18:59+00:00","description":"Untuk menyegarkan semua tabel pivot sekaligus, Anda dapat menggunakan VBA, tombol segarkan, atau opsi tabel","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Actualiser-manuellement-tous-les-tableaux-croises-dynamiques-en-un-seul-clic.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Actualiser-manuellement-tous-les-tableaux-croises-dynamiques-en-un-seul-clic.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/menyegarkan-semuanya\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menyegarkan semua tabel pivot?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2171","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=2171"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2171\/revisions"}],"predecessor-version":[{"id":2796,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2171\/revisions\/2796"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}