{"id":417910,"date":"2022-03-17T18:00:06","date_gmt":"2022-03-17T15:00:06","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-refresh-a-pivot-table-in-microsoft-excel\/"},"modified":"2022-03-17T18:00:06","modified_gmt":"2022-03-17T15:00:06","slug":"how-to-refresh-a-pivot-table-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-refresh-a-pivot-table-in-microsoft-excel\/","title":{"rendered":"#How to Refresh a Pivot Table in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2a6d6f0ab1c\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2a6d6f0ab1c\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-refresh-a-pivot-table-in-microsoft-excel\/#%E2%80%9CHow_to_Refresh_a_Pivot_Table_in_Microsoft_Excel%E2%80%9D\" >&#8220;How to Refresh a Pivot Table in Microsoft Excel&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-refresh-a-pivot-table-in-microsoft-excel\/#Refresh_a_Pivot_Table_Manually\" >Refresh a Pivot Table Manually<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-refresh-a-pivot-table-in-microsoft-excel\/#Refresh_a_Pivot_Table_Automatically\" >Refresh a Pivot Table Automatically<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-refresh-a-pivot-table-in-microsoft-excel\/#Prevent_Formatting_Changes_Upon_Update\" >Prevent Formatting Changes Upon Update<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Refresh_a_Pivot_Table_in_Microsoft_Excel%E2%80%9D\"><\/span>&#8220;How to Refresh a Pivot Table in Microsoft Excel&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" data-pagespeed-lazy-srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" width=\"1200\" height=\"675\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Using a pivot table, you can analyze large amounts of data easily. But as we all know, data can and often does change. To make sure that your data is current, here\u2019s how to refresh a pivot table in Excel.<\/p>\n<p>Whether the data in your pivot table comes from an external source or the same workbook, you can update it manually or automatically. You can also adjust a setting so that the formatting doesn\u2019t change when you update the table.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Refresh_a_Pivot_Table_Manually\"><\/span>Refresh a Pivot Table Manually<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you would prefer to update your pivot table manually when needed, start by selecting the table.<\/p>\n<p>Go to the PivotTable Analyze tab that <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ears. Click the Refresh drop-down arrow in the Data section of the ribbon.<\/p>\n<p>To refresh the selected pivot table, choose \u201cRefresh.\u201d To refresh all pivot tables in your workbook, choose \u201cRefresh All.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-789547\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/RefreshOrAll-ExcelRefreshPivotTable-1.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Refresh or Refresh All for a pivot table\" width=\"650\" height=\"410\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Alternatively, you can right-click the pivot table and choose \u201cRefresh\u201d in the shortcut menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-789548\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/Refresh-ExcelRefreshPivotTable-1.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Refresh in the shortcut menu\" width=\"528\" height=\"497\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If the update takes a bit of time, you can select Refresh &gt; Refresh Status to see the progress. To cancel, choose Refresh &gt; Cancel Refresh.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Refresh_a_Pivot_Table_Automatically\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_1\">Refresh a Pivot Table Automatically<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Maybe you\u2019d rather that your <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/407943\/what-are-pivot-tables-in-google-sheets-and-how-do-i-use-them\/\">pivot table update each time you open the workbook. This is a good way to always have refreshed data and saves you from remembering to manually update the table.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>What are Pivot Tables in Google Sheets, and How Do I Use Them<\/em><\/strong><\/p>\n<p>Select the pivot table and go to the PivotTable Analyze tab. On the left side, use the PivotTable drop-down arrow and click Options &gt; Options.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-789543\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/PivotTableOptions-ExcelRefreshPivotTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Open the pivot table Options\" width=\"269\" height=\"366\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the PivotTable Options window, select the Data tab. Then, check the box for Refresh Data When Opening the File. Click \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-789546\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/AutomaticUpdate-ExcelRefreshPivotTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Refresh when opening the file\" width=\"564\" height=\"470\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Prevent_Formatting_Changes_Upon_Update\"><\/span>Prevent Formatting Changes Upon Update<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Sometimes the data that gets updated is wider than your <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/290817\/how-to-set-row-height-and-column-width-in-excel-using-the-keyboard\/\">column width or longer than your row height. If you want to retain the formatting for your columns and rows when you refresh a pivot table, it\u2019s a simple setting.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Set Row Height and Column Width in Excel Using the Keyboard<\/em><\/strong><\/p>\n<p>Select the pivot table and go to the PivotTable Analyze tab. On the left side, use the PivotTable drop-down arrow and then click Options &gt; Options.<\/p>\n<p>In the PivotTable Options window, select the Layout &amp; Format tab. Then, check the box for Preserve Cell Formatting on Update. Optionally, you can check the box directly above for Autofit Column Widths on Update. Click \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-789545\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/03\/PreserveFormatting-ExcelRefreshPivotTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Preserve pivot table formatting\" width=\"520\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Keep your data current and up to date by refreshing your pivot table in Excel, either manually or automatically.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Use Pivot Tables to Analyze Excel Data<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/789536\/how-to-refresh-a-pivot-table-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Refresh a Pivot Table in Microsoft Excel&#8221; Using a pivot table, you can analyze large amounts of data easily. But as we all know, data can and often does change. To make sure that your data is current, here\u2019s how to refresh a pivot table in Excel. Whether the data in your pivot&#8230;<\/p>\n","protected":false},"author":1,"featured_media":417911,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-417910","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/417910","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=417910"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/417910\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/417911"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=417910"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=417910"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=417910"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}