What is eating up my memory the PowerPivot / Excel edition

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

A common question asked is what columns in my model are using the most memory. Earlier I created a workbook that was able to get the memory for a Tabular server which you can download here but that didn't work with an embedded Excel Data model or PowerPivot workbook.

But I recently found a new way that would allow me to get this information in PowerPivot / Excel 2013 using a macro. Many thanks to Ken Puls who helped me clean up the macro and give me some great Excel tips. It always great to see SQL and Excel folks learn things from each other :) . Thanks to his help this macro, once created, will be accessible for all workbooks without having to change the individual workbooks.

Read more...

Tags: excel, management, memory

 

2007-2015 VidasSoft Systems Inc.