{"id":250,"date":"2014-09-24T13:49:45","date_gmt":"2014-09-24T11:49:45","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=250"},"modified":"2024-06-05T17:12:42","modified_gmt":"2024-06-05T15:12:42","slug":"refresh-pivot-table","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/refresh-pivot-table\/","title":{"rendered":"Refresh a Pivot Table"},"content":{"rendered":"<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\/refresh-pivot-table\/#Refresh_a_Pivot_Table\" title=\"Refresh a Pivot Table\">Refresh a Pivot Table<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Refresh_a_Pivot_Table\"><\/span>Refresh a Pivot Table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When the information in your data set gets updated you need to Refresh your <a class=\"wpil_keyword_link\" title=\"Pivot Table\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a> to see those changes in your Pivot Table.\u00a0 There are three ways to do this.\u00a0 First click on your Pivot Table and:<\/p>\n<p>1. From the Ribbon choose: PivotTable Tools &gt; Options &gt; Refresh<\/p>\n<p>2.Press ALT+F5<\/p>\n<p>3.Right click in your Pivot Table and choose Refresh (see this option below)<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Refresh-a-Pivot-Table.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Refresh-a-Pivot-Table.xlsx\" 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\">Refresh-a-Pivot-Table.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>Change the information in your data set.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/04-refresh-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6702\" title=\"Refresh a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/04-refresh-01.jpg\" alt=\"Refresh a Pivot Table\" width=\"635\" height=\"226\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/04-refresh-01.jpg 635w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/04-refresh-01-300x107.jpg 300w\" sizes=\"(max-width: 635px) 100vw, 635px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong> <\/span>Click in the Pivot table.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/04-refresh-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6703\" title=\"Refresh a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/04-refresh-02.jpg\" alt=\"Refresh a Pivot Table\" width=\"473\" height=\"181\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/04-refresh-02.jpg 473w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/04-refresh-02-300x115.jpg 300w\" sizes=\"(max-width: 473px) 100vw, 473px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong> <\/span>Right click and select\u00a0<strong>Refresh<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/04-refresh-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6704\" title=\"Refresh a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/04-refresh-03.jpg\" alt=\"Refresh a Pivot Table\" width=\"591\" height=\"228\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/04-refresh-03.jpg 591w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/04-refresh-03-300x116.jpg 300w\" sizes=\"(max-width: 591px) 100vw, 591px\" \/><\/a><\/p>\n<p>The Pivot Table values are now updated!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/04-refresh-04.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6705\" title=\"Refresh a Pivot Table\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/04-refresh-04.jpg\" alt=\"Refresh a Pivot Table\" width=\"472\" height=\"182\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/04-refresh-04.jpg 472w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/04-refresh-04-300x116.jpg 300w\" sizes=\"(max-width: 472px) 100vw, 472px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Refresh a Pivot Table When the information in your data set gets updated you need to Refresh your Pivot Table to see those changes in your Pivot Table.\u00a0 There are three ways to do this.\u00a0 First click on your Pivot Table and: 1. From the Ribbon choose: PivotTable Tools &gt; Options &gt; Refresh 2.Press ALT+F5 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17731,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Refresh a Pivot Table","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[17,4],"tags":[87,86],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/250"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=250"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/250\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17731"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=250"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=250"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=250"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}