How to Troubleshoot Memory Errors in Excel; "Available Resources", "Out of Memory", "System Resources"

Thanks for the feedback the “available resources” post!  We realized that many people are getting these type of memory issues in Excel and are looking for some answers.  So we wrote a detailed KB that addresses most of the common memory issues. If you are seeing any of the following messages; “Excel cannot complete this…


"Excel cannot complete this task with available resources" after installing MS12-030 (updated)

After you install MS12-030 (Vulnerabilities in Microsoft Excel could allow remote code execution – http://support.microsoft.com/kb/2663830) you may see the following error message appear when trying to do sorts in your spreadsheet: “Excel cannot complete this task with available resources. Choose less data or close other applications.” Updated – 6/28/2012 – a fix for this problem…