Inserting rows slow on large report

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?
 
W

Wilpeter

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

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.
 
R

Robbro

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

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.
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top