|
Show
the Pivot Cache Memory Used
You can display the memory used by a pivot cache, by using the following
User Defined Function. Store the function code in a worksheet module.
Then, on the worksheet, enter the formula:
=GetMemory(A3)/1000
replacing A3 with a cell in your pivot table. The result is displayed
in kilobytes.

Function GetMemory(rngPT As Range) As Long
Dim pt As PivotTable
Set pt = rngPT.PivotTable
GetMemory = ActiveWorkbook _
.PivotCaches(pt.CacheIndex).MemoryUsed
End Function
|