What is pivot cache in Excel VBA?
Pivot Cache is generated with the creation of the Pivot Table. It is a data source’s replica holding object. Pivot Cache is a part of the workbook and pivot table. Every time any changes are required in the pivot table, pivot cache is used instead of the table.