The Secret behind Excel PivotTables – The Pivot Cache

Microsoft Excel Tips and Tricks

The hidden way PivotTables work, the limitations this imposes, and how to get around them.

Credit MyOnlineTrainingHub