Improving Excel memory and file performance

Improving Excel memory and file performance

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.