"Excel cannot complete this task with available resources..."

[Dougmeister]

"Choose less data or close other applications. Continue without Undo?"

Been Googling this error and have not yet found a solution.

It is a very simple workbook. I have one tab with raw data, and a 2nd tab that pulls data from the 1st tab and formats it. I also use sub-strings, "find", etc. as shown below:

=LEFT('(Tab1)'!A356,FIND(":",'(Tab1)'!A356))
or
=TRIM(RIGHT('(Tab1)'!A357,LEN('(Tab1)'!A357)-LEN(A357)))

I reset the workbook every month. I find that, as the # of rows increase, the problem occurs more frequently. If I save and close the workbook, I can copy and paste about 5 rows of the above formulas. It takes a few minutes for it to finish pasting (which is ridiculously slow). If I try for a second round of "copy and paste", it will almost always result in the error.

Am I missing something here?

 

[Leith Ross]

Hello Dougmeister,

Trying saving the files as an xlsb. This creates a binary file which removes a lot of the bloat created by the xlsx which is an XML file version. It will also run faster.

 

[Dougmeister]

I also have macros in the book, so it is currently saved as an XLSM file.

 

[FACTOR 21]

The macros will still run when saved as XLSB

 

[Dougmeister]

Ok. I did not realize that; I'll try it and report back. Thanks.

 

[Dougmeister]

Still happening.

 

[Dougmeister]

(bump)

Any other ideas?

 

[Dougmeister]

bumpity-bump-bump