Excel cannot complete this task with available resources

nayr1482

Board Regular
Joined
Feb 2, 2009
Messages
74
I have a macro written that inserts a row and slides the data below it down. This has worked fine forever.
However, now the file apparently has grown to the point where when it tries to insert a row towards the top of the data set, I get the error "Excel cannot complete this task with available resources. Choose less data or close other applications."

I have confirmed I get the same error when I try to manually insert a row at that location.
I have tried this on multiple PCs with same error.

I am able to select the data below that row and drag it down 1 row without error (currently...as the data set grows I'm not sure).



Any options / ideas on how to deal with this?
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Jambi46n2

Board Regular
Joined
May 24, 2016
Messages
243
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
I would try selecting all empty rows below until the bottom of the spreadsheet, and doing a "Clear Contents" or "Delete Rows"
Same goes for all Empty Columns to the right. There could be hidden data there that is exceeding the row limitations of Excel.
 

nayr1482

Board Regular
Joined
Feb 2, 2009
Messages
74
I would try selecting all empty rows below until the bottom of the spreadsheet, and doing a "Clear Contents" or "Delete Rows"
Same goes for all Empty Columns to the right. There could be hidden data there that is exceeding the row limitations of Excel.

Thanks for the suggestion - gave it a try but still same error persists.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,186
Messages
5,570,749
Members
412,339
Latest member
sstackho
Top