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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.