Forum Discussion
Excel cannot complete this task with available resources. Choose Less data or close others applicati
I developed a report for my business user. During the development I used Windows 64 bit and Excel 2013 64 bit version for developing marco. My code have some arrays and looping function. After finishing, It worked well with my computer and others computers which operated by windows 64 bit version. when I test with my users whose OS is 32 bit but the excel version is 2013 32-bit version. The errors appear while running the loop and array command. The errors is "Excel cannot complete this task with available resources. Choose Less data or close others application". I have tried to figure out the solution by closing other applications or program, but still did not work. I have checked so solutions and said it is better to upgrade to excel 64 bit version. This solution require to upgrade the windows as well. Are there any other solutions which is not require to upgrade the OS or to simplify my code by avoid using array and loop?
2 Replies
Follow these links you may find a solution in them:
How to troubleshoot "available resources" errors in Excel
Excel cannot complete this task with available resources error
I think that your code may need some refinements and optimizations, try to explicitly declare all variables, set Option Explicit to On., use the appropriate data types and so on.
It's up to you and your experience as a VBA developer.
Thanks so much. I have tried Option Explicit, but I still got the same problem when I tested with 32-bit version.
