Excel 2007 - Error inserting column

[Greg Lovern]

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

 

[Greg Lovern]

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