Extremely slow subtotals in Excel 2003

[GARY]

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 are:
'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?

 

[Pete_UK]

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

Pete

 

[GARY]

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?

 

[Bob I]

Buy a faster PC.

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?