Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2010 - Out of memory? Not enough resources.

01 Mar 2012   #1
lolalou

Windows 7 Professional 64 bit SP1
 
 
Excel 2010 - Out of memory? Not enough resources.

When a user is opening a second Excel sheet the following error message appears: 'Excel cannot complete this task with available resources. Choose less data or close other applications.'

The files are saved on a network drive and I am able to open them fine on my PC which is the exact same spec and setup. I have deleted the files in C:\users\username\appdata\microsoft\excel and rebooted the PC but the error still appears. It is happening to all sheets, no matter their size or content, most don't have macros.

Don't know what else to try?!


My System SpecsSystem Spec
.
01 Mar 2012   #2
lolalou

Windows 7 Professional 64 bit SP1
 
 

The above fix did sort it, I just wasn't told!
My System SpecsSystem Spec
01 Mar 2012   #3
GEWB

Several flavors of Linux (Mint primary) / 32bit XP, Win7 HomeP / 64bit Win7 Pro, Ultimate / 64Win8.1
 
 

Take a look at what apps are loaded and running - see the lower right corner of the screen. If there is a bunch of "stuff" running that isn't required to do the job, close them (OneNote, Office Upload Center or whatever it's called, RSS feeds, manufacturer's "utilities" - you get the idea).

Excel 2010 - Out of memory? Not enough resources.-runningapps.png

The open the Task Manager and look at the running processes. Click the Memory column header to sort by memory use - evaluate and take appropriate course of action.

Excel 2010 - Out of memory? Not enough resources.-memoryuse.png

Next look at the Performance tab for more clues.

Excel 2010 - Out of memory? Not enough resources.-perfcharts.png


Regards,
GEWB


My System SpecsSystem Spec
.

01 Mar 2012   #4
GEWB

Several flavors of Linux (Mint primary) / 32bit XP, Win7 HomeP / 64bit Win7 Pro, Ultimate / 64Win8.1
 
 

Our posts crossed in the ether - glad you got it fixed!

I'll leave my first reply as it may help someone else.

Regards,
GEWB
My System SpecsSystem Spec
11 Jun 2012   #5
thorr686

Windows 7 Professional x64
 
 
Extreme Gratitude

I have been encountering this issue for quite a while, but every fix I found through MS Support did not help at all.

This fix worked on all affected machines (5 of them)

Thank you so MUCH!

Kudos
My System SpecsSystem Spec
08 Aug 2012   #6
kane639

Windows 7
 
 
What is the fix?

I"m sorry maybe I'm missing something here, but what is the "fix" that is being referred to? I've been having this issue with Excel every time I open more than one document. But I don't see what solution is offered here?

Please advise, thanks.
My System SpecsSystem Spec
08 Aug 2012   #7
GEWB

Several flavors of Linux (Mint primary) / 32bit XP, Win7 HomeP / 64bit Win7 Pro, Ultimate / 64Win8.1
 
 

Stopping unnecessary programs and services to free up memory (as I recall but my memory isn't what it used to be).

Regards,
GEWB
My System SpecsSystem Spec
09 Aug 2012   #8
kane639

Windows 7
 
 
Out of Memory Not Enough Resources

Interesting... thanks for the reply.

When looking at the thread here, it appears that it's out of sequence where yours follows the first two from lolalou who appeared to have it "fixed" before your suggestion appears. Thus, I didn't expect this was the solution.

Nonetheless, I wouldn't think the answer would be something this simple because I've actually seen tons of these issues in web searches and several suggestions but no real fix. My laptop, where this issue occurs, is newer and more advanced than my home PC. Yet my home PC never had this issue and I typically am running an equal amount of resources on both.

Just in case, I'll pay attention to that.

Thanks.
My System SpecsSystem Spec
13 Sep 2012   #9
PC GURU

Windows 7 Pro 64 bit
 
 
This Worked for us!!

I tried every fix on the internet for the "not enough resources" error in Excel 2010 with no luck. It wasn't until I started looking at the version of Excel that I had a break through. By default Office is installed as 32-bit, but you can install a 64-bit version that allows Office to use all the resources that a work station has. 32 bit Excel only allows 2GB, whereas 64 uses all resources. This link explains how you should use 64 bit Office 2010 and how to install 64-bit editions of Office 2010 We have accountants that work with huge spread sheets and would always run into this issue after Office upgrade to 2010, once I switched them to Office 64-bit the problem stopped. I would only suggest to use 64-bit for users that work with large excel documents and/or get the memory error, keep 32-bit as default, this has worked great for us. BTW go to file>help in any Office 2010 program to see what version you are running, most likely it's 32-bit. Hope this helps someone out there because I know this error drove me nuts!!
My System SpecsSystem Spec
25 Feb 2014   #10
MrPsiko

Windows 7 x64 Enterprise
 
 

I know this thread is long since deceased, but I felt a great need to thank PC GURU for his/her extremely helpful answer. I, too, was driven up a wall with this error in my office - users with large amounts of RAM were still getting this error on 32-bit installations of Office 2010 and for the life of me I couldn't figure it out. Sometimes even single, simple workbooks generated the error.

My Google-fu failed to find any decent solution and took me only further into the weeds.

Now that I know it's a built-in "feature", management can/will purchase 64-bit editions for our numbers-loving accountants.

Thanks for saving me!
My System SpecsSystem Spec
Reply

 Excel 2010 - Out of memory? Not enough resources.




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
Memory Leak: Insufficient System Resources
My practice is to turn off the machine at bedtime and reboot it every morning, so that it gets a fresh start every day. I upgraded to Windows-7 from -XP about a month ago, applied all available updates and thought it the right move until recently. Now after the machine runs several hours, when I...
Performance & Maintenance
Excel 2010 spreadsheet taking up almost 1gb of memory
So I have a .xlsx spreadsheet of about 1.5mb taking up nearly 1gb of memory. Simple workbook consisting of about 5 sheets with standard formatting and some colors. I deleted all unnecessary rows and columns, ran 449898_intl_x64_zip hotfix, and rebuilt Excel registry and managed to get down...
Microsoft Office
Excel 2010
Hello, I'm having this weird problem with MS Office 2010. When I'm working on excel files tend to crash for no reason and too frequently when I try to open them. I have gotten these two messages: 1) Excel cannot complete this task with available resources. Choose less data or close other...
Microsoft Office
Excel 2010 help
I have a document in Excel 2010 which contains 2 columns. Data from 2nd column is constant, does not change and is assigned to data in 1st column. Names and surnames are great example, so I will use this case for explanation. Currently there are 200 unique names in 1st column and of course 200...
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 19:54.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App