Excel 2010 crashes when deleting rows RRS feed

  • Question

  • I have a rather large spreadsheet (30MB) that calculates statistics and creates control charts for multiple data points.

    I "stress tested" the sheet by having it able to hold 30K rows of data.

    Now I'm trying to delete unnecessary formula rows and Excel crashes each and every time.  I even went as far as trying VBA to select one row at a time and loop through to delete each one.  Still crashes.  Any ideas?

    • Edited by machina20 Tuesday, May 6, 2014 3:23 PM
    Tuesday, May 6, 2014 3:10 PM