# Calc crashes when inserting/deleting row(s) [closed]

It's a problem that I encounter already for a long time, also with OpenOffice. My Calc workbook sometimes crashes when I insert one or more rows. Or when I delete one or more rows. Lately it got worse and crashes happens quite often.

I started searching for errors and finally started deleting sheets until the problem disappeared. Well, the crashing stopped when I deleted a sheet with about 400 sumproduct-functions in it. Now I think that the sumproduct-function is to "blame" because when I keep the sheet, but just delete the sumproduct-functions, the crashing of Calc did not occur. Keeping a few of the sumproduct-functions in the sheet was also OK, but Calc has problems with more than a few sumproduct-functions...

My sumproduct-function looks as follows: =SUMPRODUCT((Range1="Q1"),(Range2=$B47),Range3)

Any ideas for improvement, or is it a Calc bug?

Jaap

Can you provide a sample file? I don't understand why your SUMPRODUCT formula points to a range with a single cell...