Insert Rows/Columns in large workbook

[wbemis]

I have a large workbook (approx 70MB) w/ approx 100 similar tabs. When I try inserting rows & columns (w/ all tabs highlighted), Excel 2010 tries to process for several mins, then says I don't have the resources to complete the operation. Is there anything I can do to help it along? I have 8GB & i5 2.53 laptop.
I greatly appreciate any ideas.

 

[poolhall]

I never worked with such large workbooks. If your workbook xml-based (has xlsx or xlsm extentions), back your file up and then convert it to <tt>*.xlsb.

If this doesn't help significantly, I guess you'd have no other option but to disable automatic calculation. When you insert a row/column, you will have to manually recalculate. Use </tt>SHIFT+F9 to recalculate the active worksheet or F9 to recalculate the entire workbook. Then see what happens
<tt>
</tt>

 

[wbemis]

Thanks so much for the reply! Can you plz explain a little more about .xlsb? I can't find much about it. BTW, I'm using Excel 2010.

 

[poolhall]

xlsb is a binary format, the same zip container instead of XML data containing binary data, and is recommended for very large workbook to improve performance. I can't tell for sure but I doubt it will help significantly. You really need to try and see if there's noticeable difference.