Inserting rows slow on large report

[Robbro]

I have a large report I maintain with 3 data tabs and 2 report tabs, 1 for
top 10 customers, about 400 rows, and another for all other customers, about
4000 rows. Every month I have to update it for any new customer/product
combinations. I have optimized the formulas to the best of my abilities and
gotten a full recalc time down from 3 min to 30 sec, which is acceptable. My
biggest problem now is that every time I need to add a row (or delete one for
that matter) it takes about 15 seconds (on the 4k row report, adding to the
top 10 customers report takes 3-5 seconds), per row. I'm adding hundreds per
month so this gets very tedious. I have turned formula calculation to normal
but it still fairly long to add or remove rows. Is there anything else I can
do or is this just the result of a very long report?

 

[fooreest]

free up some RAM-memory or consider about buying RAM memory

 

[Wilpeter]

Have you tried setting Calculation to Manual while inputting these changes,
then resetting it to Automatic afterwards? F9 becomes the calc button
meanwhile.

 

[Dave Peterson]

If you see those dotted page lines (after a print or a print preview), then turn
them off.

In xl2003 menus:
tools|options|view tab|uncheck page breaks

If you're in page break preview mode, then go back to normal.

Turn calculation to manual.

If you have events that fire, turn them off.

 

[Robbro]

Ah, had a typo in my post, I put normal, but I had already changed formula
calculations to manual. Didnt really change anything.

 

[Robbro]

I'm in office 07 and I've made sure I have no page previews on. Its on
"normal" under the view tab. Already turned calc's to manual.

Really just wondering if I should give up looking for a solution or not,
dont think there is much else to try.

 

[Dave Peterson]

I can't think of anything else.

I'm in office 07 and I've made sure I have no page previews on. Its on
"normal" under the view tab. Already turned calc's to manual.

Really just wondering if I should give up looking for a solution or not,
dont think there is much else to try.