Share this question

Welcome to Teachnovice Q&A, where you can ask questions and receive answers from other members of the community.

This is a collaboratively edited question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Excel cannot complete this task with available resources. Choose less data or close other application.

0 like 0 dislike
2,893 views
Excel cannot complete this task with available resources. Choose less data or close other application.
asked Jan 3, 2012 by anonymous  
retagged Apr 19, 2013

1 Answer

0 like 0 dislike
1. Check RAM / Page Size ( if it is less add more RAM and Page Size)
2. Delete all rows which are not being used and save to sheet.
3. None above works. Make sure user does not have lot of sheet in the workbook.
 
Try again now it should be fixed.
answered Jan 3, 2012 by anonymous  
...