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
Network Folder and Excel Sharing with read only issues
My office has a shared network folder with shared excel spreadsheets used by multiple persons at the same time. We have always had slow connectivity, but after moving the shared folder to another network server (in another city) we are having major issues, to name a few: 1-Read only pops up all...
Network & Sharing
Excel ('13) - "Document not saved" error + performance issues
Hi, Issue is with an Excel document that runs a macro to report information from another data sheet: Raw data - 3MB Macro - 8MB Result file - 120MB When the macro is complete; 1. The document shows an error when trying to save (see screenshot with error) -- Black icons show within the save...
Microsoft Office
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
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


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 18:07.
Twitter Facebook Google+