Running on a P4 2.8 GHz w/1 GB RAM...
Excel 2003.
I have a worksheet w/roughly 9000 rows and 18 columns of data.
When subtotaling the data, my CPU is maxing out, while RAM seems to be fine.
The process is taking too long (up to a minute) to calculate the subtotals.
The behavior gets worse as additional subtotals are added.
Has anyone experienced this?
Is thier anything that I can do to improve performance?
Thank you.
Bookmarks