Inserting rows slow on large report

  • Thread starter Thread starter Robbro
  • Start date Start date
R

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?
 
Have you tried setting Calculation to Manual while inputting these changes,
then resetting it to Automatic afterwards? F9 becomes the calc button
meanwhile.
 
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.
 
Ah, had a typo in my post, I put normal, but I had already changed formula
calculations to manual. Didnt really change anything.
 
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.
 
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.
Click to expand...
 
Back
Top