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 and resource issues

20 Mar 2012   #1
BSeanD

Windows 7
 
 
Excel and resource issues

Hi Guys,

I have a staff member who is having Virtual memory issues when running Office 2007 Excel. She has a minimal amount of programs open and also has plenty of disk space and RAM available but at times she gets the following error.

Excel and resource issues-excelerror.jpg

This does not happen every time she opens excel or a particular spreadsheet but seems to be happening at random. The logs have the following entry;

Faulting application name: EXCEL.EXE, version: 12.0.6654.5003, time stamp: 0x4ebd97cb
Faulting module name: EXCEL.EXE, version: 12.0.6654.5003, time stamp: 0x4ebd97cb
Exception code: 0xc0000005
Fault offset: 0x0003a44c
Faulting process id: 0x158
Faulting application start time: 0x01cd061850b9a2c8
Faulting application path: C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXE
Faulting module path: C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXE
Report Id: 1160bbed-7246-11e1-8e0b-002643fa484c
[/HTML]

A reboot fixes the problem but this isn't really solving much.

Can someone point me in the right direction on how I can solve this one.

Thanks,

Sean




My System SpecsSystem Spec
.
20 Mar 2012   #2
JDobbsy1987

Windows 8.1 Pro x64
 
 

Hi Sean,

Regardless of the amount of memory the host machine has, Excel 2007 as a memory limit of 2GB i believe.
Is excel using anywhere near that when getting this error?

How about trying this?
Frustrating Excel 2007 issue - Tech Support Forum
Quote:
by chance is this an upgraded Office installation? Mine was. I deleted the contents of "c:\documents and settings\%username%\application data\microsoft\excel" and rebooted the computer. The folder contents were re-created the next time I opened Excel and I haven't had the problem return since then.
Path for Windows 7 is - C:\Users\<username>\AppData\Roaming\Microsoft\Excel

Regards,
JDobbsy1987
My System SpecsSystem Spec
20 Mar 2012   #3
BSeanD

Windows 7
 
 

Hey JDobbsy1987,

The files are no where near 2Gig in size at the time of the "crash" the two files open were 109kb and the other being opened was 34.3kb.
I'll have a read of the forum link you posted and see how I go there.

Thanks,

Sean
My System SpecsSystem Spec
.

20 Mar 2012   #4
JDobbsy1987

Windows 8.1 Pro x64
 
 

Quote   Quote: Originally Posted by BSeanD View Post
Hey JDobbsy1987,

The files are no where near 2Gig in size at the time of the "crash" the two files open were 109kb and the other being opened was 34.3kb.
I'll have a read of the forum link you posted and see how I go there.

Thanks,

Sean
I was referring to a 2gb RAM limit within Excel, when you get this error check task manager and see how much memory excel.exe is using up.

Regards,
JDobbsy1987
My System SpecsSystem Spec
20 Mar 2012   #5
seavixen32

Windows 7 Ultimate SP1 64-Bit
 
 

You may find this Microsoft article of help: Excel 2010 error: Excel cannot complete this task with available resources.

You might also want to download Process Explorer to see how your RAM is being used. It may just be that Excel has run out of RAM because of other processes that may be running at the time.

http://technet.microsoft.com/en-us/s...rnals/bb896653

The 32-bit version of Excel has a 2GB memory limit so if you are running a lot of processes the message could then be triggered as you near that limit.

If you're using Excel as a database had you considered using Access instead?
My System SpecsSystem Spec
20 Mar 2012   #6
JDobbsy1987

Windows 8.1 Pro x64
 
 

My System SpecsSystem Spec
20 Mar 2012   #7
BSeanD

Windows 7
 
 

Quote:

I was referring to a 2gb RAM limit within Excel, when you get this error check task manager and see how much memory excel.exe is using up.

Regards,
JDobbsy1987
D'oh sorry, busy day not concentrating.
My System SpecsSystem Spec
20 Mar 2012   #8
BSeanD

Windows 7
 
 

Quote   Quote: Originally Posted by seavixen32 View Post
You may find this Microsoft article of help: Excel 2010 error: Excel cannot complete this task with available resources.

You might also want to download Process Explorer to see how your RAM is being used. It may just be that Excel has run out of RAM because of other processes that may be running at the time.

Process Explorer

The 32-bit version of Excel has a 2GB memory limit so if you are running a lot of processes the message could then be triggered as you near that limit.

If you're using Excel as a database had you considered using Access instead?
Hi Seavixen,

The files hold pretty minimal data and are not being used as a database.
So with the 2GB limit if she gets the error message again I need to check total memory usage on Excel and the overall memory usage?
My System SpecsSystem Spec
20 Mar 2012   #9
PooMan UK

Windows 7 Ultimate 64bit
 
 

I had a similar issue a while back with a client who had the same problem as yours. The relatively small excel file was originally created with office 2003. When they upgraded to office 2007 the problem started. I re-installed 2003 on the problem PC and the issue went away. The strange thing is that it only happens on one of the 4 identical upgraded machines.
My System SpecsSystem Spec
20 Mar 2012   #10
BSeanD

Windows 7
 
 

Quote   Quote: Originally Posted by PooMan UK View Post
I had a similar issue a while back with a client who had the same problem as yours. The relatively small excel file was originally created with office 2003. When they upgraded to office 2007 the problem started. I re-installed 2003 on the problem PC and the issue went away. The strange thing is that it only happens on one of the 4 identical upgraded machines.
Hey PMan,

This is not on an upgrade, our office has the 2007 version of Office.


Sean
My System SpecsSystem Spec
Reply

 Excel and resource issues




Thread Tools




Similar help and support threads
Thread Forum
Issues with Excel 2003 files
Dear Experts, please can you help? When I create Excel documents using Excel 2003 on my Windows 7 system it saves them as 'OOBE.' documents. If I try to open them from 'My Computer' it says it cannot open them (the Open With option does not suggest Excel). However if I open Excel first then go...
Microsoft Office
Excel Issues on Thin Client
Not sure how applicable this is to a windows 7 forums, but i thoughts i'd ask I have an issue since upgrading office on my thin client server, i've gone from 2003 to 2007. whats happening is, we use 'Track Changes' function alot as there are multiple users editing single files. some of the...
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
Excel 2000 display issues
Has anyone encountered this issue before with Excel 2000 in Windows 7 (professional 32bit). We are testing windows 7 on some Pc, and those users are using Office 2000. Everything works fine, however, sometimes users launch excel (by double clicking on an XLS file) and excel come up like the...
Microsoft Office
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office
Excel 2003 - Multiple Excel Open
Hi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it...
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 03:36.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App