{"id":2170,"date":"2023-09-26T08:17:01","date_gmt":"2023-09-26T08:17:01","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/alles-vernieuwen\/"},"modified":"2023-12-06T05:51:10","modified_gmt":"2023-12-06T05:51:10","slug":"alles-vernieuwen","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/alles-vernieuwen\/","title":{"rendered":"Hoe vernieuw ik alle draaitabellen?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-354277826\"><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>Geloof me, als je alle draaitabellen tegelijkertijd kunt vernieuwen, kun je veel tijd besparen. Ja het is waar. Denk zo. Je hebt 10 draaitabellen en het verversen van \u00e9\u00e9n draaitabel duurt een seconde.<\/p><p> <strong>10 draaipunten = 10 seconden<\/strong><\/p><p> Net zoals u het <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/nl\/draaitabel-1\/\" data-wpel-link=\"internal\" data-wpil=\"url\">maken van een draaitabel kunt automatiseren,<\/a> zijn er verschillende manieren waarop u deze kunt gebruiken om deze automatisch te vernieuwen. In dit artikel zal ik 3 eenvoudige methoden met u delen die u kunt gebruiken om alle draaitabellen en uw tijd te vernieuwen.<\/p><h2 class=\"wp-block-heading\"> Gebruik de knop \u201cAlles vernieuwen\u201d om alle draaitabellen in de werkmap bij te werken<\/h2><p> De knop &#8220;Alles vernieuwen&#8221; is een eenvoudige en gemakkelijke manier om alle draaitabellen in een werkmap met \u00e9\u00e9n klik te vernieuwen. <\/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=\"Vernieuw alle draaitabellen handmatig met \u00e9\u00e9n klik\"><\/figure><\/div><p> Het enige wat u hoeft te doen is naar het tabblad Gegevens \u279c Verbindingen \u279c Alles vernieuwen te gaan.<\/p><h2 id=\"tab-con-2\" class=\"wp-block-heading\"> Vernieuw automatisch alle draaipunten wanneer u een werkmap opent<\/h2><p> Als u alle draaitabellen wilt vernieuwen bij het openen van een werkmap, kunt u de volgende stappen gebruiken om hiervoor een eenmalige configuratie uit te voeren. <\/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=\"Ververs alle draaitabellen bij het openen van een bestand\"><\/figure><\/div><p> Hieronder vindt u de stappen die u kunt gebruiken om alle draaitabellen automatisch te vernieuwen wanneer u een werkmap opent.<\/p><ol><li> Selecteer een van de draaitabellen in uw werkmap.<\/li><li> Klik er met de rechtermuisknop op en selecteer &#8216;Opties voor draaitabel&#8217;.<\/li><li> Ga naar het tabblad Gegevens \u279c Vink \u201cGegevens vernieuwen bij het openen van een bestand\u201d aan.<\/li><li> Klik OK.<\/li><\/ol><h2 class=\"wp-block-heading\"> VBA-code om alle draaitabellen met \u00e9\u00e9n klik bij te werken<\/h2><p> Ja, u kunt VBA ook gebruiken om alle draaitabellen te vernieuwen. Het enige dat u hoeft te doen, is simpelweg de onderstaande code gebruiken.<\/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> De bovenstaande code vernieuwt alle draaitabellen in uw actieve werkblad en u kunt deze macro ook toewijzen aan een knop die u met een enkele klik kunt gebruiken.<\/p><h3 class=\"wp-block-heading\"> Vernieuw alleen specifieke draaitabellen met VBA<\/h3><p> Als u specifieke draaitabellen heeft die u wilt bijwerken, kunt u de onderstaande VBA-code gebruiken.<\/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> Wijzig de naam van de draaitabellen volgens uw werkmap. En als u deze aangepaste draaitabellen elke keer wilt bijwerken wanneer u een werkmap opent, wijzigt u de macronaam in <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\"> Meer informatie over draaitabellen<\/h2><ol><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/nl\/koppel-de-slicer-aan-verschillende-draaitabellen\/\" data-wpel-link=\"internal\">Verbind een enkel segment met meerdere draaitabellen<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/nl\/koppel-de-slicer-aan-verschillende-draaitabellen\/\" data-wpel-link=\"internal\">Automatisch een draaitabelbereik bijwerken<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/nl\/groepsdata\/\" data-wpel-link=\"internal\">Groepeer datums in een draaitabel<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/nl\/tijdlijnfilter\/\" data-wpel-link=\"internal\">Draaitabeltijdlijn<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/nl\/dynamische-tabel-kruisverwijzingen-naar-verschillende-bestanden\/\" data-wpel-link=\"internal\">Draaitabel met meerdere bestanden<\/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-2170","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>Hoe vernieuw ik alle draaitabellen?<\/title>\n<meta name=\"description\" content=\"Om alle draaitabellen in \u00e9\u00e9n keer te vernieuwen, kunt u VBA, de vernieuwingsknop of tabelopties gebruiken\" \/>\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\/nl\/alles-vernieuwen\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe vernieuw ik alle draaitabellen?\" \/>\n<meta property=\"og:description\" content=\"Om alle draaitabellen in \u00e9\u00e9n keer te vernieuwen, kunt u VBA, de vernieuwingsknop of tabelopties gebruiken\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/alles-vernieuwen\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:51:10+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=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/alles-vernieuwen\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/alles-vernieuwen\/\",\"name\":\"Hoe vernieuw ik alle draaitabellen?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/alles-vernieuwen\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/alles-vernieuwen\/#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-06T05:51:10+00:00\",\"description\":\"Om alle draaitabellen in \u00e9\u00e9n keer te vernieuwen, kunt u VBA, de vernieuwingsknop of tabelopties gebruiken\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/alles-vernieuwen\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/alles-vernieuwen\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/alles-vernieuwen\/#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\/nl\/alles-vernieuwen\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe vernieuw ik alle draaitabellen?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hoe vernieuw ik alle draaitabellen?","description":"Om alle draaitabellen in \u00e9\u00e9n keer te vernieuwen, kunt u VBA, de vernieuwingsknop of tabelopties gebruiken","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\/nl\/alles-vernieuwen\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe vernieuw ik alle draaitabellen?","og_description":"Om alle draaitabellen in \u00e9\u00e9n keer te vernieuwen, kunt u VBA, de vernieuwingsknop of tabelopties gebruiken","og_url":"https:\/\/exceladvisor.org\/nl\/alles-vernieuwen\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:51:10+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":{"Geschatte leestijd":"2 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/alles-vernieuwen\/","url":"https:\/\/exceladvisor.org\/nl\/alles-vernieuwen\/","name":"Hoe vernieuw ik alle draaitabellen?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/alles-vernieuwen\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/alles-vernieuwen\/#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-06T05:51:10+00:00","description":"Om alle draaitabellen in \u00e9\u00e9n keer te vernieuwen, kunt u VBA, de vernieuwingsknop of tabelopties gebruiken","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/alles-vernieuwen\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/alles-vernieuwen\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/alles-vernieuwen\/#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\/nl\/alles-vernieuwen\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe vernieuw ik alle draaitabellen?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2170","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=2170"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2170\/revisions"}],"predecessor-version":[{"id":2822,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2170\/revisions\/2822"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=2170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}