Forum Discussion

catkckozich's avatar
catkckozich
Copper Contributor
Mar 19, 2023

Excel shuts down when trying to insert a row. any ideas on why this is happening and how to fix?

Excel shuts down when trying to insert a row. any ideas on why this is happening and how to fix?

3 Replies

  • mstemp's avatar
    mstemp
    Copper Contributor

    Tested and verified:

    I had a worksheet and every time I tried to insert a column or a row, Excel would crash. After reviewing many other posts with recommended solutions, I found my answer.

    I had these two array function formulas in two columns of a table. Thus, these functions appeared on every row of the table.

    =MIN(Hours_per_Week,SUM(BYCOL($H7:$N7, LAMBDA(day, MIN(day, Hours_per_Day)))))

    =LET(OTHrs,SUM(BYCOL($H7:$N7, LAMBDA(day, MAX(day-Hours_per_Day, 0)))),
    MAX(O7-P7,OTHrs))

    After deleting these formulas, I could insert columns and rows as expected.  It's a shame these elegant functions do not work but I was able to implement another solution.

    Problem solved.

  • mstemp's avatar
    mstemp
    Copper Contributor

    Tested and verified:

    I had a worksheet and every time I tried to insert a column or a row, Excel would crash. After reviewing many other posts with recommended solutions, I found my answer.

    I had these two array function formulas in two columns of a table. Thus, these functions appeared on every row of the table.

    =MIN(Hours_per_Week,SUM(BYCOL($H7:$N7, LAMBDA(day, MIN(day, Hours_per_Day)))))

    =LET(OTHrs,SUM(BYCOL($H7:$N7, LAMBDA(day, MAX(day-Hours_per_Day, 0)))),
    MAX(O7-P7,OTHrs))

    After deleting these formulas, I could insert columns and rows as expected.  It's a shame these elegant functions do not work but I was able to implement another solution.

    Problem solved.

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    catkckozich 

    There could be several reasons why Excel crashes when trying to insert a row.

     

    One reason could be that the worksheet has a lot of conditional formatting applied to it.

    When conditional formatting is applied separately for each row, Excel crashes when adding a new row at the end of the table.

     

    Another reason could be that a COM add-in is causing the problem.

    You can try to determine if a COM add-in is causing the problem by clicking

    File > Options > Add-ins > COM Add-ins,

    and then clearing all the check boxes in the list, and clicking OK.

     You can then close and restart Excel in normal mode (not in safe mode)

     

    If the above solutions do not work, you can try opening the worksheet with which you’re experiencing difficulties inserting new table rows and selecting the inactive space below the active area of your table. You can try to select the inactive space below the active area of your table and insert a new row

     

Resources