Refresh your data in Pivot

Here’s a worst-case scenario worthy of a horror film soundtrack: You’ve been working with your data for hours, and you’ve built tons of different pivot tables from your source data, just like we did earlier here.

You take another look at some of your pivot tables, and you realize that you made a mistake—you have a typo in your data set. You accidentally spelled “growler” as “grolwer,” for example, and now it appears that way everywhere.

Do you need to go through the workbook with a fine-tooth comb to correct that error everywhere it appears in his data and his pivot tables? Absolutely NOT. All he needs to do is:

1. Return to the raw data set where the pivot tables are pulling from and do a “find and replace.” Hit Ctrl + F and then enter in what he wants to identify, and what should be swapped out in its place.

 2. Doing so corrected all appearances of “grolwer” in his data set, but not in any of the pivot tables that are linked to that data.

3. To make that update everywhere, go to the “Data” tab in the ribbon and then click the “Refresh All” button. That will make that same correction across the entire workbook.

With these articles... I hope you are ready to make the most of pivot tables

After basics of pivot tables, you have it - six advanced pivot table techniques that you should definitely know. Put them to work, and you’ll make summarizing and analyzing your data a total breeze.

Eager to know even more about how to leverage the power of pivot tables to your advantage? reach us on excelprosteam@gmail.com. you’ll transform yourself into a bonafide pivot table pro before you know it!

Thanks for reading, Happy Excel Learning!