28 June 2014
If you have sluggish Excel models, it might not just be the file size that is slowing things down. Often it's the memory being used and when things get really bad, you might even get a "Not enough Memory" or "Not enough system resources to display completely" error message.
When you get this frustrating message, the only solution is to close Excel and restart it, so let's look at some ways to improve the performance of your Excel models.
Full article: Improving Excel memory and file performance