Updating pivot tables

It will dock to the last docked location (either to the right or left side).

You can get more screen real estate by hiding the Pivot Table Fields window.

Without a table your range reference will look something like above.

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.

You can also access this feature by right clicking on any value then selecting Show Details. Tip: change your data set to a table before you insert a pivot table. On the Analyze tab, in the Data group, click Change Data Source.If you change any of the text or numbers in your data set, you need to refresh the pivot table. If you change the size of your data set by adding or deleting rows/columns, you need to update the source data for the pivot table. This way your data source will be updated automatically when you add or delete rows/columns.

Leave a Reply