Extremely slow subtotals in Excel 2003
 

My worksheet has 16,000 rows and 10 columns. (Row 1 contains the
column headings).

It takes only a minute or two to get subtotals of the cells in the
selected columns. (The worksheet -- with the subtotal rows --then
has
49,000 rows).


To the left of the spreadsheet a
'1' (which displays all rows)
'2' (which displays only the subtotals)
'3' (which displays the Grand Total).


When I click '2', "Calculating Cells: 100%" is displayed for HOURS in
the Status Bar.


The Windows Task Manager shows that "Microsoft Excel" is "Running";
the CPU Usage = 50%; the Commit Charge = 318M/5984M; the Mem Usage
for
Excel.Exe is 64,780K; the Physical Memory (K) readings are Total =
2095188; Available = 1559000; System Cashe = 512216.


(Ending all non-critical processes doesn't speed up Excel or allow me
to run any other applications on my PC).


What's causing this situation and what can I do?

Extremely slow subtotals in Excel 2003
 

It sounds like you have 33,000 rows (of 10 columns ?) with a subtotal
formula in - that's a lot of formulae !!

Pete

On Mar 8, 12:54 am, "GARY" wrote:
My worksheet has 16,000 rows and 10 columns. (Row 1 contains the
column headings).

It takes only a minute or two to get subtotals of the cells in the
selected columns. (The worksheet -- with the subtotal rows --then
has
49,000 rows).

To the left of the spreadsheet a
'1' (which displays all rows)
'2' (which displays only the subtotals)
'3' (which displays the Grand Total).

When I click '2', "Calculating Cells: 100%" is displayed for HOURS in
the Status Bar.

The Windows Task Manager shows that "Microsoft Excel" is "Running";
the CPU Usage = 50%; the Commit Charge = 318M/5984M; the Mem Usage
for
Excel.Exe is 64,780K; the Physical Memory (K) readings are Total =
2095188; Available = 1559000; System Cashe = 512216.

(Ending all non-critical processes doesn't speed up Excel or allow me
to run any other applications on my PC).

What's causing this situation and what can I do?

Extremely slow subtotals in Excel 2003
 

If an Excel worksheet can have up to 65,536 rows and 256 columns, it
should easily be able to handle a worksheet with only 33,000 rows
(with subtotal formulas) and 10 columns. (That's less than 20% of the
max).

My question is: What's causing the extremely-slow processing and what
can I do about it?



On Mar 7, 5:27 pm, "Pete_UK" wrote:
It sounds like you have 33,000 rows (of 10 columns ?) with a subtotal
formula in - that's a lot of formulae !!

Pete

Extremely slow subtotals in Excel 2003
 

Buy a faster PC.

GARY wrote:

If an Excel worksheet can have up to 65,536 rows and 256 columns, it
should easily be able to handle a worksheet with only 33,000 rows
(with subtotal formulas) and 10 columns. (That's less than 20% of the
max).

My question is: What's causing the extremely-slow processing and what
can I do about it?



On Mar 7, 5:27 pm, "Pete_UK" wrote:

It sounds like you have 33,000 rows (of 10 columns ?) with a subtotal
formula in - that's a lot of formulae !!

Pete