Delay when deleting row

**Marcelo Rychter** · 01-05-2013, 04:00 PM

Hi everybody,

I have a very large workbook, with 10 sheets. After installing Excel 2010 it takes 4 minutes to delete one single row, in all the sheets.

I have one sheet in this workbook that has lots of series of numbers, with 10 decimals (only values - no formulas). It has 4.000 rows and 200 columns. When I delete this sheet the problem is solved: it takes only one second to delete a row.

On the other hand, when I keep this sheet and change all the numbers to only 2 decimals (roundind and copying values) the problem also disapear.

I think that the problem is related to numbers with many decimals in Excel 2010. But I need to work with this precision to my calculus.

Have you heard something about that? How can I avoid the problem?

Thanks in advance,
Marcelo Rychter

**Tsjallie** · 01-05-2013, 04:16 PM

Did you try switching off automatic calculation before deleting rows?

**xladept** · 01-05-2013, 04:22 PM

Here's a routine to toggle the calculation mode that I use continuously:

Please Login or Register  to view this content.

**Marcelo Rychter** · 01-06-2013, 06:57 AM

Originally Posted by Tsjallie

Did you try switching off automatic calculation before deleting rows?

Thanks for you answer, Tsjallie.

But I've tried to switch off calculation and the time is exactly the same.

Cheers,
Marcelo Rychter

**Tsjallie** · 01-06-2013, 02:45 PM

I'm not aware of numbers with a lot of decimals slowing down excel.
Using many formulas, specially sumif constructions, however do when calculation is switch on.
Are there any other event procedures in the workbook?
Acually I would like to have a lok at your workbook if possible.