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.

30 Apr 2014   #11
icy1964

Windows 7 pro, SP1 64 bit
 
 

I have a file that is displaying same symptoms

In my case this is with a small file (6.5 MB with no calculations)
This file also takes and extraordinarily long time to open (30-90 secs)
The problem is occurring on several computers that I have tried (including with Windows 8 & Excel 13)
I'm not even able to delete 1 row of data (30-40 columns with data)
I have other bigger files with pivot tables etc. and these have no problem.
This seems to be a file issue, but I have been unable to resolve it.

64 bit edition seems to be an overkill as the standard (recommended) version should do this easily.
"this additional capacity is needed only by those Microsoft Excel users who require Excel spreadsheets that are larger than 2 gigabytes (GB). "

The suggestions by Microsoft support don't have any effect

I have noticed over that last year or more that excel seems to struggle with memory, especially with bigger files.

Any help or suggestions would be appreciated
#evernoteContentClipperWait { FONT-FAMILY: arial, helvetica, sans-serif; PADDING-BOTTOM: 0px; PADDING-TOP: 0px; PADDING-LEFT: 0px; MARGIN: 0px; Z-INDEX: 2147483647; DISPLAY: block; PADDING-RIGHT: 0px; opacity: 1}#evernoteContentClipperWait * { DISPLAY: block !important; text-shadow: none}.quirk-mode-container#evernoteContentClipperWait { WIDTH: 160px}#evernoteContentClipperWait DIV.content-less-than-nine-container#evernoteContentClipperWaitContent { FILTER: progidXImageTransform.Microsoft.Alpha(opacity=80); BACKGROUND-COLOR: rgb(0,0,0)}DIV#evernoteContentClipperWaitContent { FONT-SIZE: 10pt; HEIGHT: 100%; FONT-FAMILY: arial, helvetica, sans-serif; BACKGROUND: black; COLOR: white; PADDING-BOTTOM: 9px; PADDING-TOP: 9px; PADDING-LEFT: 15px; PADDING-RIGHT: 15px; WIDTH: 100%; border-radius: 5px; opacity: .8}#evernoteContentClipperWaitText { FLOAT: none; PADDING-BOTTOM: 0px; PADDING-TOP: 0px; PADDING-LEFT: 0px; MARGIN: 0px; DISPLAY: inline; LETTER-SPACING: 1pt; LINE-HEIGHT: 18px; PADDING-RIGHT: 0px}#evernoteContentClipperWait IMG { BORDER-TOP: medium none; BORDER-RIGHT: medium none; BORDER-BOTTOM: medium none; FLOAT: left; PADDING-BOTTOM: 0px; PADDING-TOP: 0px; PADDING-LEFT: 0px; MARGIN: 0px 0px 0px 4px; BORDER-LEFT: medium none; DISPLAY: inline; PADDING-RIGHT: 0px}DIV#evernote-spinner-container { HEIGHT: 18px; FLOAT: left; WIDTH: 20px}' ; // get html // ======== var _html = _response; // normalize // ========= _html = _html.replace(//gi, '>'); _html = _html.replace(/\s+\/>/gi, '/>'); // remove // ====== _html = _html.replace(/#next_pages_container { POSITION: absolute; LEFT: -100px; Z-INDEX: 2147483647 !important; TOP: -100px; WIDTH: 5px; hight: 5px}


My System SpecsSystem Spec
.
07 Apr 2015   #12
Alivallo

Windows 7
 
 
UN-Check Preview pane and Details pane in all Office programs

Microsoft suggested workaround is to go to:

Windows Explorer --> Layout ---> uncheck preview pane and details pane.
OUTLOOK --> add attachment --> layout --> uncheck here too
Excel --> open document --> layout --> uncheck these here too.
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 23:47.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App