Subtotals in Excel 2003

[GARY]

In the status bar, why is "Calculating Cells: 100%" being displayed
for HOURS?

The Windows Task Manager shows:

under the Applications tab, that "Microsoft Excel" is "Running". (The
CPU Usage doesn't change from 50% and the Commit Charge doesn't change
from 318M/5984M).

under the Processes tab, the Mem Usage for Excel.Exe is 64,780K.

under the Performance tab, the Physical Memory (K) readings are about:
Total = 2095188; Available = 1559000; System Cashe = 512216.


Even ending all other non-critical processes doesn't do anything to
speed up Excel.


(In the meantime, I can't use any other applications on my PC).

 

[Jim Thomlinson]

Subtotaling in XL is a horribly slow process if you get beyond about 10,000
rows. That is just the way it is. Have you considered a pivot table instead?
It will work for you so long as no one aggregation field (like account number
or name) has more than 8,000 different values. A pivot table will take only a
couple of seconds to process and you can appy formats to it and a whole bunch
of funky things... The do pretty much everything subtotals will do and a
whole bunch more.