PDA

View Full Version : excel can't complete this task with available resources.



suny100
05-29-2011, 11:31 AM
I have make many codes in my excel workbook, it works fine for 2 days then it gives me this msg when i try to run code which cut and paste rows or even when i cut or delete it manually "excel can't complete this task with available resources. choose less data or close other application "

I don't know what is going here ?




here is link where i ask about same problem
http://www.excelforum.com/excel-programming/777923-excel-cant-complete-this-task-with-available-resources.html#post2534363

Simon Lloyd
05-29-2011, 12:40 PM
You are probably exceeding the system memory, if you are cutting and pasting...etc try doing it in smaller pieces and see what you get.

suny100
05-29-2011, 03:38 PM
You are probably exceeding the system memory, if you are cutting and pasting...etc try doing it in smaller pieces and see what you get.


give the same msg also

Aussiebear
05-29-2011, 08:42 PM
Have you tried Simon's solution?

suny100
05-30-2011, 09:24 AM
Have you tried Simon's solution?


yes i do , and it give me the same msg

Simon Lloyd
05-30-2011, 02:57 PM
It has very little to do with Excel but more to do with the allocation of resources on your pc.

suny100
05-31-2011, 12:55 PM
It has very little to do with Excel but more to do with the allocation of resources on your pc.


no i have good memory allocation , and it give me same msg on another PC

Aussiebear
05-31-2011, 03:21 PM
Have you altered any of the codes in any way? Increased their ranges etc?

Paul_Hossler
05-31-2011, 05:07 PM
http://www.appspro.com/Utilities/CodeCleaner.htm



About the VBA Code Cleaner
During the process of creating VBA programs a lot of junk code builds up in your files. If you don't clean your files periodically you will begin to experience strange problems caused by this extra baggage. Cleaning a project involves exporting the contents of all its VBComponents to text files, deleting the components and then importing the components back from the text files

Highly recommended. Solves my problems a lot of the time (well, OK .. my Excel problems at least)

Paul

suny100
06-01-2011, 11:47 AM
http://www.appspro.com/Utilities/CodeCleaner.htm


Highly recommended. Solves my problems a lot of the time (well, OK .. my Excel problems at least)

Paul

Paul , it didn't give me any errors ,it give me msg of successful operation, this problem make me crazy all my work is stop