Not a question but an observation, really.
PivotTable.PivotCache.MemoryUsed takes an aweful long time on large pivots.
MemoryUsed: 524.476kB
Time Taken: 00:00:05 seconds
5 seconds? For a half MB pivot? What the heck, Excel...are you using your fingers to count?
PivotTable.PivotCache.MemoryUsed takes an aweful long time on large pivots.
Code:
Sub test()
Dim start As Date
start = Now()
Debug.Print "MemoryUsed: " & ActiveCell.PivotTable.PivotCache.MemoryUsed / 1000 & "kB"
Debug.Print "Time Taken: " & Format(Now() - start, "HH:MM:SS") & " seconds"
End Sub
MemoryUsed: 524.476kB
Time Taken: 00:00:05 seconds
5 seconds? For a half MB pivot? What the heck, Excel...are you using your fingers to count?