What is pivot cache in Excel VBA?

1.	What is pivot cache in Excel VBA?
Answer» 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.

Discussion