Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1839
  • Last Modified:

Excel cannot complete this task with available resources.

Having an issue with Excel 2003 on Windows XP. Getting an error message: Excel cannot complete this task with available resources. Choose less data or close other applications. If you click OK, it comes up like 10 times and you have to keep clicking OK. Tried closing out other applications and clicking OK, but it still pops up. Tried updating office 2003 to latest patches, updates, etc. still occurs. Not everyday, but often. Any suggestions?
0
nsiguy123
Asked:
nsiguy123
  • 8
  • 4
  • 3
  • +1
3 Solutions
 
drewha1969Commented:
Can you provide more details?  What are you trying to do when you receive this error?  It sounds like you are trying to manipulate too much data and are running out of memory...
0
 
Haris DjulicCommented:
had same problem and still do sometimes...

the issue is that you are updating your excel from somewhere and the excel does not have sufficient memory to open the link and update the data..

what you should do is close unnecessary applications and then try  or try to reopen your excel since it may have some data in the some kind of "buffer" ... or in case that you are updating from other excel open it since it will reduce the links...



0
 
nsiguy123Author Commented:
The message appears when I open 1 additional file that pushes it over the edge and error message says it's on overload. Then I try to close the error message, which pops up 10 times, and then i close some excel sheets.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
nsiguy123Author Commented:
will adding additional memory fix this issue then?
0
 
drewha1969Commented:
Sounds like samo4fun is on the right track.  I actually had this problem today with OpenOffice.  I had to close some brower windows and try again.

If that fails, try opening the additional file and splitting it up.  For example, I was trying to link a text file from our web logs this morning.  The first try, OpenOffice ran out of memory.  I closed some applications and it worked the second time.  But, if that were to fail, I could have cut and pasted half of the text file into a separate text file, then linked them 1 at a time.
0
 
drewha1969Commented:
If you think you will be running these types of tasks on a regular basis, then adding more memory would probably help.  How much is hard to say (probably max your machine out).  You would just have to price memory for your system and see if the cost is worth it or you can do a work around like I suggested earlier.
0
 
nsiguy123Author Commented:
thanks. need to update windows to sp3. seems its not using my memory to its entirety. thanks for everyone's help.
0
 
warturtleCommented:
How much RAM do you have currently? and how many applications do you have open at the same time when this happens? It could also be a virus that is consuming memory in the background. It might be worth checking for viruses by downloading MalwareBytes Anti-Malware (www.malwarebytes.org). This is basically an antispyware scanner and will scan for spyware in your PC.
0
 
drewha1969Commented:
Unfortunately, I dont think updating to SP3 will make Windows utilize your memory more efficiently.  At least not enough to fix your problem.  How big is the file you are trying to open?
0
 
nsiguy123Author Commented:
i will try upgrading to sp3 and malwarebytes on the pc tomorrow. im not the one particularly having the issue. its a friend of mine at work.
0
 
Haris DjulicCommented:
any progress with this issue?
0
 
nsiguy123Author Commented:
no update yet. i scanned with malware in safemode. no issues there. updated pc to SP3, and even updated the bios from the dell website. Since this doesnt happen everyday i'll have to wait and see how this progresses over the next week. ill keep you all informed. thank you.
0
 
warturtleCommented:
Another thing to watch is the startup items. You can access them by Start->Run->msconfig

Then have a look in the startup tab for more information on what is in there. Disable all unneeded entries either from msconfig or from within the applications themselves.
0
 
nsiguy123Author Commented:
update: still having issues. seems this occurs when copying and pasting spreadsheets when many workbooks are open. any other ideas?
0
 
warturtleCommented:
I am going to suggest disabling any addons that you have within Excel, that might help.
0
 
nsiguy123Author Commented:
haven't had a chance to check. i'm thinking i may just rebuild her machine. what do you all think?
0
 
nsiguy123Author Commented:
Thank you for your help. I will just have to rebuild her machine. Just wanted to give you guys credit for your dedication and support.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 8
  • 4
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now