Updating pivot tables

A new sheet will be created with only the data relating to that value.

You can also access this feature by right clicking on any value then selecting Show Details.

Select a cell in your pivot table and then go to the Analyze tab in the ribbon.

Press the Field List button in the Show section to toggle the Pivot Table Fields window on or off.

If you change any of the text or numbers in your data set, you need to refresh the pivot table.

In this example, if we were to add data past Row 51 or Column I our pivot table would not include it in the results. Now when you create a pivot table you can reference it with a name instead of a range.

When you add data to the table, you won’t need to update the range in your pivot table.

Just refresh it and the new data will appear in your results.

If the ability to show the detailed data behind a pivot table result doesn’t interest you, then you can turn this feature off.

This means you and can avoid creating new sheets with bits of data in them because of accidental double clicks.

You’re gonna learn all the tips the pros use, so get ready for a very very long post!