Inserting rows slow on large report
 

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?

Inserting rows slow on large report
 

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

"Robbro" wrote in message
...
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?

Inserting rows slow on large report
 

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

"Robbro" wrote:

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?

Inserting rows slow on large report
 

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 wrote:

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?

--

Dave Peterson

Inserting rows slow on large report
 

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


"Wilpeter" wrote:

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

"Robbro" wrote:

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?

Inserting rows slow on large report
 

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" wrote:

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 wrote:

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?

--

Dave Peterson
.

Inserting rows slow on large report
 

I can't think of anything else.

Robbro wrote:

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" wrote:

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 wrote:

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?

--

Dave Peterson
.


--

Dave Peterson