Insert Rows/Columns in large workbook

wbemis

New Member
Joined
Sep 15, 2010
Messages
2
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.
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

poolhall

Active Member
Joined
Jan 9, 2009
Messages
350
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

New Member
Joined
Sep 15, 2010
Messages
2
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

Active Member
Joined
Jan 9, 2009
Messages
350
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,624
Messages
5,469,771
Members
406,669
Latest member
Rubrob

This Week's Hot Topics

Top