I created a dashboard based on Power Pivot data. I have about 18 pivot tables in the dashboard and on running the code below, I was pretty surprised to find that there are 18 pivot caches present in the workbook.
I usually create a new pivot table by copying an existing one as that is supposed to help avoid creation of multiple pivot caches but looks like Power Pivots work a different way.
To confirm, I created a new pivot based on an existing pivot and count increased to 19!
Are things different with PowerPivot or am I doing something wrong?
Code:
Sub CountCaches()
MsgBox "There are " _
& ActiveWorkbook.PivotCaches.Count _
& " pivot caches in the active workook."
End Sub
I usually create a new pivot table by copying an existing one as that is supposed to help avoid creation of multiple pivot caches but looks like Power Pivots work a different way.
To confirm, I created a new pivot based on an existing pivot and count increased to 19!
Are things different with PowerPivot or am I doing something wrong?