| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Slow Subtotaling
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. |
|
#2
|
|||
|
|||
|
try using sumproduct instead with the parameters of the filter. Example.
=sumproduct((rngA="a")*(rngB=1)*rngC) -- Don Guillett SalesAid Software "Jeremy" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| slow page break previews | Excel Discussion (Misc queries) | |||
| MY EXEL/WORD OFFICE 2000 IS RUNNING VERY SLOW AFTER DOWNLOADING U. | Excel Discussion (Misc queries) | |||
| Slow opening files - possible cause and solutoin | Excel Discussion (Misc queries) | |||
Hybrid Mode
