Automatic Refresh Probably one of the greatest benefits of the PIVOTBY function is that it recalculates and changes shape automatically whenever the data source changes.

A pivot table in Microsoft Excel reorganizes data quickly into a meaningful report, and it's easy to use!

Microsoft has announced a beta version of Excel that allows pivot tables to automatically update themselves when data is changed.