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

[Mighty Whites]

Does anyone know why this error message comes up and what to do to rectify it?

 

[james_lankford]

not enough memory ?
what is is running ? a browser ? adobe auto update ?

 

[Mighty Whites]

I'm on a network PC, would the fact that our shared drive is nearly at full capacity have anything to do with it?

 

[Stormseed]

Duplicate:

http://www.mrexcel.com/forum/showthread.php?t=216808

Edit:

Oh, sorry. I missed out to see that the threads are started by 2 different members.

 

[Mighty Whites]

ADVERTISEMENT

Thanks Stormseed, much appreciated

 

[pbornemeier]

I encountered one instance of this error message while I was copying and inserting a worksheet. Changing my procedure to inserting a blank worksheet then copying the usedrange of the source worksheet eliminated this problem.

From researching the error message, there seems to be multiple problems that generate this message.

 

[XL Pro]

ADVERTISEMENT

I'm experiencing this problem in XL2007. The macro runs fine in 2000/2003, but runs afoul of this "error" in 2007. My procedures do copy worksheets, but I've always used the method pbornemeier suggested. Is there any way around this error via VBA?

 

[XL Pro]

No help?

 

[Adgurl]

Duplicate:

http://www.mrexcel.com/forum/showthread.php?t=216808

Edit:

Oh, sorry. I missed out to see that the threads are started by 2 different members.

I tried this other thread and it has a link to the MS Support forum. There was a question posted there, but no answers to the problem.

 

[jmthompson]

Does your macro include anything that uses a full column, like "G:G"?

Excel 2007 doesn't like this because of the nearly-unlimited number of rows available. Excel 2007 prefers that you identify the last row of the desired range, instead.