I'm getting the error "Excel cannot complete this task with available
resources. Choose less data or close other applications." trying to
insert a column in Excel 2007. Works fine in Excel 2003 on the same
worksheet.

The worksheet has 59,604 rows and 16 columns. I have 2GB of RAM on
this computer.

The error happens on this line:

<whole-column range object.Insert Shift:=xlToRight

Again, it works fine in Excel 2003 (SP2), with the same data on the
same computer.

I tried rebooting, didn't help.


Is Excel 2007 more limited than Excel 2003 in the amount of data it
can move around?

I guess I'm probably going to have to do this in pieces. Any other
suggestions?


Thanks,

Greg

More information:

It doesn't help to do it in pieces; I get the same error even
inserting just a single cell (!).

However, it works fine to insert the column interactively.

I hope I don't have to use SendKeys to work around that. For now, I'm
going to try moving the occupied columns that would have been moved by
the Insert.


Any suggestions?


Thanks,

Greg


On Aug 6, 8:54 pm, Greg Lovern wrote:
I'm getting the error "Excel cannot complete this task with available
resources. Choose less data or close other applications." trying to
insert a column in Excel 2007. Works fine in Excel 2003 on the same
worksheet.

The worksheet has 59,604 rows and 16 columns. I have 2GB of RAM on
this computer.

The error happens on this line:

<whole-column range object.Insert Shift:=xlToRight

Again, it works fine in Excel 2003 (SP2), with the same data on the
same computer.

I tried rebooting, didn't help.

Is Excel 2007 more limited than Excel 2003 in the amount of data it
can move around?

I guess I'm probably going to have to do this in pieces. Any other
suggestions?

Thanks,

Greg