Deleting & Inserting Rows

[Chris Taylforth]

I have a spreadsheet that contains around 3000 lines with
18 columns. On each individual line there are 3 formula's.
As the spreadsheet becomes larger it is taking a long time
(2 - 3 min or even longer) to delete or insert rows. Also
when I am cutting and pasteing it is also taking a long
time. I would like to know if this is normal or I have I
got something wrong with the spreadsheet. As I have
previously had a similar sized spreadsheet which didn't
have these problems with.

Regards
Chris Taylforth
Austwide Wholesalers

 

[Frank Kabel]

Hi
depending on the type of your formulas this could be
normal. As you haven't posted your used formulas (for
posible optimisations) you could try to disable automatic
calculation while you insert/delete rows.

 

[David McRitchie]

Hi Chris,
Is that 3000 rows based on what you see or based on the last cell (Ctrl+End)

If there is a difference then see
http://www.mvps.org/dmcritchie/excel/lastcell.htm#makelastcell

If you are using SUM on each row referring to all of the rows above then
you would have serious problems with time.

Check to see if you have a lastcell problem and post formulas so we can
see what you are doing. Are these builtin Excel worksheet formulas or
are these User Defined Functions (functions you programmed in VBA).

additional reading material:
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
http://groups.google.com/groups?as_umsgid=ugDxrXayCHA.2592@TK2MSFTNGP10