Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Resolved Question

Excel - Limited resources error keeps crashing Excel 2010

Jan 15, 2015 9:12PM PST

Good Morning:
Windows 7 (64 Bit) and Excel 2010 (32 Bit)

I have an end user who has created documents and created separate Excel worksheets imported data from SAP. Now, 2 people in our company have this issue with Excel. She is getting error messages saying:
"Excel cannot complete this task with available resources. Choose less data or close other applications."
1. We have taken out the Store and display links under START MENU in the toolbar. We have deleted all TEMP files in Users Profile, in the Windows directory and used the Disk Cleaner to cover the rest.
2. We right clicked on the START BUTTON and Opened Windows Explorer (and Excel and Outlook) Clicked Organize | Layout and Unchecked the Details Pane and Preview Pane.
3. We ran the FIXIT program and found nothing extraordinary.
Does anyone have any ideas out there on how to resolve this error from coming up on pretty much any file she opens?

Also, does the 64 Bit version of Excel give more RAM Memory to the application?

Thanks for your help on this matter.

James

Discussion is locked

JJWTech has chosen the best answer to their question. View answer

Best Answer

- Collapse -
Re: resources
Jan 15, 2015 10:36PM PST

Such a message was common back in Windows 98, but you hardly see it nowadays. Check the virtual memory settings and the free disk space. And indeed, close other programs running. And maybe these users have exceptional things in their personal macro files and such?

If all is fine on other PC's and you can't find a specific cause, then just go back to the factory or company image.

Kees

- Collapse -
Answer
Excel issue
Jan 16, 2015 12:00AM PST

Windows 7 - 64 Bit
Office 2010 - 32 Bit
Intel Dual Core i7
16 GByte Ram


No, this happens rarely but on the Windows 7 platform. They have Excel and they just have added the data - some small files - others larger. Some are imported from SAP while others are basic. There are no unique NAMES used in the end users formulas or lookups in other spradsheets - so that can be elimintated.

I was wondering if I install 64 bit Office if there are problems it creates or if you cannot share files with a 32 Bit user. I would think it could open up the RAM (which they have 16 GIGABYTES) - sometimes 32 bit is limited in RAM Memory access (i.e. 4 GByte Max)???

- Collapse -
Answer
About the 32 to 64 bit question
Jan 16, 2015 12:13AM PST

Yes it may give more resources but it's far too complicated for me to go beyond "more."

It seems rare to push Office apps to this extreme. Usually such work is left to custom apps. I've seen folk push Office apps to the edge and complaints like yours happen.

It's worth noting that Excel is a spreadsheet and not a database. Sometimes folk forget the basic differences and try to use Excel like a database.
Bob