How to Refresh Pivot Table Data in Excel 2013

Pivot tables in Excel 2013 are very helpful tools that let you quickly view the data from your spreadsheets in whatever way you need. Pivot tables can be easily manipulated and sorted without requiring you to edit or delete any of the important original data that is in your spreadsheet.

But you might discover that the information you are seeing in your pivot table needs to be updated, either because it has been changed, or you noticed that it was incorrect. However, that data may not be updating automatically in your pivot table once you change it in the source spreadsheet. Luckily there is a way to refresh your pivot table after you have updated the spreadsheet data on which the pivot table was based.


How to Update an Excel 2013 Pivot Table

The steps in this article were performed in Microsoft Excel 2013. This guide assumes that you have already created a pivot table, but that you have recently updated the data that was used to generate the pivot table. Following these steps will cause the pivot table to check the source data again and update itself accordingly.

Step 1: Open your spreadsheet in Excel 2013.


Step 2: Make any changes to your original source data that you would like to be reflected in your pivot table.


Step 3: Select the tab at the bottom of the worksheet that contains the pivot table.

select the worksheet tab with the pivot table

Step 4: Click inside the pivot table.

click inside the pivot table



Step 5: Click the Analyze tab at the top of the window.

click the analyze tab under pivottable tools



Step 6: Click the Refresh button. Note that, rather than clicking the Refresh button in the ribbon to update your pivot table data, you can choose to press the F5 key on your keyboard instead.

how to refresh a pivot table in excel 2013



Do you need to print your spreadsheets, but something is preventing that from being simple? Learn how to optimize spreadsheets for printing in Excel and save yourself some frustration. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.