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.
mkramer777Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

[ fanpages ]IT Services ConsultantCommented:
Hi,

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.

BFN,

fp.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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?
0
broro183Commented:
hi,

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?

hth
Rob
0
broro183Commented:
hi,

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

hth
Rob
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.