Excel cannot complete this task with available resources

Keep getting the error in excel 2007 "Excel cannot complete this task with available resources.  Choose less data or close other applications. "  This happens when I'm only running outlook and excel or word and excel.  Have not seen it with only excel open.  PC has 4GB or memory.
Who is Participating?
[ fanpages ]Connect With a Mentor IT Services ConsultantCommented:

It sounds like you either need to increase the Random Access Memory [RAM] in your PC, or simply use the Microsoft Office suite products individually; not concurrently.

Are you using particularly "large" (in file size terms) workbooks?

How long ago did you re-boot your PC completely?

I am wondering if you have any "rogue" EXCEL.exe sessions (or, perhaps, other MS-Office applications) running that have failed to close properly since the last re-boot.


mkramer777Author Commented:
4GB is plenty of RAM for excel.   I used to run office xp on 512.  Must be something else. THe excel files are very small.  Rebooted this morning. I will check the extra sessions if there are any.  Any other ideas?

What are you doing when the message is displayed & what is inside your excel files?
For example, do you have lots of event macros, or formulae which either link to separate (closed) files or use full column references?

My suspicion is that you have full column references contained within formulae (perhaps vlookups?) and  that the error sometimes occurs when you are attempting to delete rows.

If you are using full column references, I suggest setting up dynamic named ranges that limit the size of the array that the formulae reference.
If you have links to closed files, could you open the linked files while you are working?


What was the solution that worked for you?

You may may find some other useful information on Charles Williams' site. Here are some brief quotes & links:

Excel uses its own pools of memory (Excel useable memory) for this workbook data. Unfortunately these memory pools are not in general as large as the Windows memory, and may well be a lot less than the RAM on your PC. Excel 95, Excel 97 and Excel 2000 have a limit for workbook formula memory of about 80 MB, and Excel 2002 has a limit of about 160MB. Excel 2003 has a limit of 1 GB and Excel 2007 has a limit which is controlled by Windows, allowing 2 GB, although differences between Excel 2003 and 2007 mean that you may not be able to use larger workbooks with 2007 than with 2003. See Memory Limits for details.
Sourced from: http://www.decisionmodels.com/memlimits.htm

Excel 2007 is limited to 2 Gigabytes of memory for the Excel process under Windows XP/Vista (Windows memory limit).
This 2 Gigabyte limit is a limit on the Virtual Memory address space. Virtual memory used by a process is larger than the working set memory reported by Windows Task Manager, so the amount of useable memory under Excel 2007 is considerably less than twice that of Excel 2003.
Because Excel 2007 (Excel12) also requires more memory to store the indexes to the increased number of rows and columns you may not be able to load larger workbooks under Excel 2007 than was possible under Excel 2003. Memory Fragmentation may also mean that it is difficult to make use of all of the available 2 GB of virtual memory.
Sourced from: http://www.decisionmodels.com/memlimitsc.htm

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.