Microsoft Excel Performance And Memory Usage

http://www.plumsolutions.com.au/articles/improving-excel-memory-and-file-performance

http://www.plumsolutions.com.au/articles/excel-model-file-size-getting-out-hand

Additional reading:
http://vbala99.blogspot.com/2015/02/excel-analyzing-filtered-set-of-data_14.html