nsiguy123
asked on
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?
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...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
ASKER
will adding additional memory fix this issue then?
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks. need to update windows to sp3. seems its not using my memory to its entirety. thanks for everyone's help.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
ASKER
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.
any progress with this issue?
ASKER
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.
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.
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.
ASKER
update: still having issues. seems this occurs when copying and pasting spreadsheets when many workbooks are open. any other ideas?
I am going to suggest disabling any addons that you have within Excel, that might help.
ASKER
haven't had a chance to check. i'm thinking i may just rebuild her machine. what do you all think?
ASKER
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.