Windows 7: 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?!

The above fix did sort it, I just wasn't told!

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).



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.



Next look at the Performance tab for more clues.




Regards,
GEWB

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

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

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.

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

Regards,
GEWB

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.

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!!