A Pivot Cache is an internal, memory-resident snapshot of the source data used to power a PivotTable.
جرّبه بالذكاء الاصطناعيWhen you create a PivotTable, Excel stores a copy of the source data in a hidden area of memory called the Pivot Cache. This structure allows the PivotTable to perform calculations and filtering rapidly without re-reading the original source range every time you change the layout.
If you create three separate PivotTables from the same data range, they can share a single Pivot Cache to significantly reduce the file size and memory usage.
The file size increases because the Pivot Cache stores a redundant copy of your source data within the workbook.