What is eating up my memory the PowerPivot / Excel edition

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.