{"id":8008,"date":"2018-04-05T16:49:32","date_gmt":"2018-04-05T14:49:32","guid":{"rendered":"https:\/\/www.myexcelonline.com\/blog\/?p=7631"},"modified":"2024-02-06T15:47:23","modified_gmt":"2024-02-06T14:47:23","slug":"automatically-refresh-pivot-table-2","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/automatically-refresh-pivot-table-2\/","title":{"rendered":"Automatically Refresh a Pivot Table"},"content":{"rendered":"<p>Have you had challenges with constantly Refreshing a <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a>?<\/p>\n<p>People forget that each time your data source gets updated that you will also need to manually <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/refresh-pivot-table\/\" target=\"_blank\" rel=\"noopener noreferrer\">Refresh your Pivot Table<\/a> in order for it to get updated and show the changes made.<\/p>\n<p>A lot of people ask if there is a way to automatically Refresh a Pivot Table, which I totally get.\u00a0 Automation is why we use Excel, right!<\/p>\n<p>Here I show you a couple of ways that you can automatically Refresh a Pivot Table.<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/XoLMJAdHQKo?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/01\/Automatically-Refresh-a-Pivot-Table-1.zip\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/01\/Automatically-Refresh-a-Pivot-Table-1.zip\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Automatically-Refresh-a-Pivot-Table-1.zip<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/automatically-refresh-pivot-table-2\/#_1_REFRESH_PIVOT_TABLE_UPON_OPENING\" title=\"\u00a0 \u00a01. REFRESH PIVOT TABLE UPON OPENING:\">\u00a0 \u00a01. REFRESH PIVOT TABLE UPON OPENING:<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/automatically-refresh-pivot-table-2\/#_2_AUTOMATIC_REFRESH_EVERY_X_MINUTES\" title=\"\u00a0 \u00a02. AUTOMATIC REFRESH EVERY X MINUTES:\">\u00a0 \u00a02. AUTOMATIC REFRESH EVERY X MINUTES:<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"_1_REFRESH_PIVOT_TABLE_UPON_OPENING\"><\/span><span style=\"color: #ff0000;\">\u00a0 \u00a01. REFRESH PIVOT TABLE UPON OPENING:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>This is a great feature and one that most people don&#8217;t know about.<\/p>\n<p>It allows you to Refresh your <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Tables\" data-wpil-keyword-link=\"linked\">Pivot Tables<\/a> as soon as you open up your Excel workbook.<\/p>\n<p>This is great if your Pivot Table&#8217;s data is linked to another workbook that gets updates by your colleagues and you only get to see the Pivot Table report.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> Right Click in your Pivot Table and choose <strong>Pivot Table Options<\/strong>:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/pivot-table-options.jpg\" rel=\"attachment wp-att-2824\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Excel Pivot Table Issues Resolved\"  class=\"alignnone size-full wp-image-2824\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/pivot-table-options.jpg\" alt=\"Top 3 Excel Pivot Table Issues Resolved\" width=\"250\" height=\"432\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/pivot-table-options.jpg 250w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/pivot-table-options-174x300.jpg 174w\" sizes=\"(max-width: 250px) 100vw, 250px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong> <\/span>Select the <strong>Data<\/strong> tab and<strong> check the &#8220;Refresh data when opening the file&#8221;<\/strong> checkbox and <strong>OK<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/aUTOMATIC-rEFRESH-1.jpg\" rel=\"attachment wp-att-2826\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Excel Pivot Table Issues Resolved\"  class=\"alignnone size-full wp-image-2826\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/aUTOMATIC-rEFRESH-1.jpg\" alt=\"Top 3 Excel Pivot Table Issues Resolved\" width=\"456\" height=\"472\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/aUTOMATIC-rEFRESH-1.jpg 456w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/aUTOMATIC-rEFRESH-1-290x300.jpg 290w\" sizes=\"(max-width: 456px) 100vw, 456px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Now each morning that you open up your Excel workbook, you can be sure that the Pivot Table is refreshed!<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"_2_AUTOMATIC_REFRESH_EVERY_X_MINUTES\"><\/span><span style=\"color: #ff0000;\">\u00a0 \u00a02. AUTOMATIC REFRESH EVERY <em>X<\/em> MINUTES:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you have your data set linked in an external data source, you can auto-refresh every <strong>x<\/strong> minutes.<\/p>\n<p>Your data can be stored in an <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-external-data-source-create-new-pivot-table\/\" target=\"_blank\" rel=\"noopener noreferrer\">external data<\/a> source such as Access, a Website, SQL Server, Azure Marketplace etc<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/external-data.jpg\" rel=\"attachment wp-att-2828\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Excel Pivot Table Issues Resolved\"  class=\"alignnone size-full wp-image-2828\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/external-data.jpg\" alt=\"Top 3 Excel Pivot Table Issues Resolved\" width=\"450\" height=\"120\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/external-data.jpg 450w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/external-data-300x80.jpg 300w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/a><\/p>\n<h2><\/h2>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>If your data is stored externally, you will need to <strong>click in your Pivot Table<\/strong> and go to <strong>Properties<\/strong> (this will only be enabled for selection if you have an external data source)<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/properties.jpg\" rel=\"attachment wp-att-2829\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Excel Pivot Table Issues Resolved\"  class=\"alignnone size-full wp-image-2829\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/properties.jpg\" alt=\"Top 3 Excel Pivot Table Issues Resolved\" width=\"157\" height=\"134\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> This will open up the<strong> Connection Properties<\/strong> and you will need to select the<strong><em> Refresh every<\/em> <\/strong>checkbox and<strong> manually set the time &amp; press OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/connection-properties.jpg\" rel=\"attachment wp-att-2831\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Excel Pivot Table Issues Resolved\"  class=\"alignnone size-full wp-image-2831\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/connection-properties.jpg\" alt=\"Top 3 Excel Pivot Table Issues Resolved\" width=\"413\" height=\"536\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/connection-properties.jpg 413w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/connection-properties-231x300.jpg 231w\" sizes=\"(max-width: 413px) 100vw, 413px\" \/><\/a><\/p>\n<p>You can now sit back and enjoy a cup of coffee whilst your Pivot Table gets\u00a0updated every few minutes:)<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff;\"><b>Automatically Refresh a Pivot Table<\/b><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline; color: #0000ff;\"><strong>Helpful Resource:<\/strong><\/span><\/p>\n<p><a href=\"http:\/\/myexcelonline.thinkific.com\/courses\/pivottable-enroll\" target=\"_blank\" rel=\"attachment wp-att-1080 noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1080 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/728x90.gif\" alt=\"Automatically Refresh a Pivot Table\" width=\"728\" height=\"90\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Have you had challenges with constantly Refreshing a Pivot Table? People forget that each time your data source gets updated that you will also need to manually Refresh your Pivot Table in order for it to get updated and show the changes made. A lot of people ask if there is a way to automatically [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17972,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[4,42],"tags":[139,330],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/8008"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=8008"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/8008\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17972"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=8008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=8008"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=8008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}