Forum Discussion
catkckozich
Mar 19, 2023Copper Contributor
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?
mstemp
Jun 10, 2025Copper 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.