Subtotal Flaw - Is this a Bug?

[Mathew]

Hi again all.

I have another concern, which I did not wish to add to my previous post about charts.
I am using a large xl workbook (circa 10mb,(30 worksheets)), with which I have the calculation as manual,
(& hit F9 every time I want to re-calculate).

However I have found that with calc on manual, when I want to insert subtotals (from the drop-down menu),
into a worksheet, xl simply stalls, and I have to ctl/alt/delete (task-manager)(end task) to get rid of this hang, and hence lose my
work.
If I change to Calc Auto, before inserting subtotal, then everything works.
Any ideas?
Using Office XP on Windows 2000 (on a network)

Cheers again,
Mathew

 

[Peo Sjoblom]

I cannot reproduce this, maybe your workbook is getting corrupt?

--

Regards,

Peo Sjoblom

Hi again all.

I have another concern, which I did not wish to add to my previous post about charts.
I am using a large xl workbook (circa 10mb,(30 worksheets)), with which I

have the calculation as manual,

(& hit F9 every time I want to re-calculate).

However I have found that with calc on manual, when I want to insert

subtotals (from the drop-down menu),

into a worksheet, xl simply stalls, and I have to ctl/alt/delete

(task-manager)(end task) to get rid of this hang, and hence lose my

 

[Ken Wright]

Hope he is keeping a backup copy safe somewhere

 

[Mathew]

Cheers Peo,
Thanks for your input - I will investigate via my IT bods.
Mathew
I cannot reproduce this, maybe your workbook is getting corrupt?

--

Regards,

Peo Sjoblom

Hi again all.

I have another concern, which I did not wish to add to my previous post about charts.
I am using a large xl workbook (circa 10mb,(30 worksheets)), with which I

have the calculation as manual,

(& hit F9 every time I want to re-calculate).

However I have found that with calc on manual, when I want to insert

subtotals (from the drop-down menu),

into a worksheet, xl simply stalls, and I have to ctl/alt/delete

(task-manager)(end task) to get rid of this hang, and hence lose my

 

[Dave Peterson]

Maybe it's just the size of the workbook that's bogging xl down.

How about moving (temporarily) that worksheet to a new workbook. Then apply
your subtotals, then move it back.

But save first--just in case.