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?

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?

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?

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

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?

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
.

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