How Will You Check The Memory Consumed By Your Pivot Table In Kilobyt

1.	How Will You Check The Memory Consumed By Your Pivot Table In Kilobytes?
Answer» You can DISPLAY the memory used by a pivot CACHE, by USING the following VBA PROPERTIES of Pivot Table. Pivot Cache.Memory Used - It returns the total memory used in bytes. Divide the result by 1024 to have it in Kilobytes. You can display the memory used by a pivot cache, by using the following VBA properties of Pivot Table. Pivot Cache.Memory Used - It returns the total memory used in bytes. Divide the result by 1024 to have it in Kilobytes.

How Will You Check The Memory Consumed By Your Pivot Table In Kilobytes?

Answer»

You can DISPLAY the memory used by a pivot CACHE, by USING the following VBA PROPERTIES of Pivot Table.

Pivot Cache.Memory Used - It returns the total memory used in bytes. Divide the result by 1024 to have it in Kilobytes.

You can display the memory used by a pivot cache, by using the following VBA properties of Pivot Table.

Pivot Cache.Memory Used - It returns the total memory used in bytes. Divide the result by 1024 to have it in Kilobytes.