If you are planning to use the smart fill feature, you should look at just using the last 2-3 rows or columns and drag rather than selecting all the content from the first row.
Excel starts calculating from the top left-hand corner, then continues across and down the sheet. A better planned design ensures you can avoid such changes. Depending on the number of impacted formulae and their complexity you could run out of memory. If you insert a new column in the spreadsheet, it forces Excel to recalculate all of the formulae affected by that insertion.
Cannot open excel not enough memory how to#
Now that you know why you have these limitations, we’ll see how to minimise their occurrence. Hence, 64-bit Excel versions can use the entire system memory giving you much better performance, but read this article about the 64-bit version of Excel before you jump straight in and upgrade. So upgrading your computer’s memory probably won’t help! The 64-bit version of Excel has boosted this memory limit exponentially. If it reaches this limit you get the error messages. So while your computer may have 4GB or even 8GB RAM, Excel can only use 2GB of that. In fact all the Excel versions after Excel 2003 were designed to use a maximum of 2GB memory. The reason for this is that Excel has its own memory manager and memory limits, regardless of the memory capacity of your machine.
If you have a RAM of more than 4GB you’ll know that your computer has ample memory – although Excel is complaining about none being available. If you get a memory error message, check the task manager for memory utilisation. Typically you might consider upgrading your RAM or switching from a laptop to a desktop to counteract these problems, but these are unlikely to help as it’s quite possibly the way that Excel is being used which is holding you back – not your machine. 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.
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. If you have sluggish Excel models, it might not just be the file size that is slowing things down.