Slow Subtotaling

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
try using sumproduct instead with the parameters of the filter. Example.

=sumproduct((rngA="a")*(rngB=1)*rngC)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extremely slow subtotals in Excel 2003 3
Slow subtotal and insert row 3
Subtotal Function response is slow 1
low speed problem 3
Subtotals in very large datasets 3
Work laptop issues 4
Excel 2003 - Inquiring about the benefits of a higher end PC. 2
Performance 2

Back
Top