I have a workbook that used to recalculate in 1 or 2 seconds under earlier versions of Excel and takes over 15 seconds in Excel 2003. This is a long time and I get lots of user complaints for which the only suggestion I have is to turn off automatic recalculation.
I tried deleting and simplifying formulae until I identified the slow cells, which is an array of about 500 cells which do lots of COUNTIF and SUMIF calculations on arrays on other sheets. If I delete any half of these formulae then the recalculate time halves and if I delete all of them then it reverts to 1 or 2 seconds.
Unfortunately I can't see any easy way to eliminate them. I really do need to know how many of each of about 20 different values occur in an array of about 70 cells in each of 25 worksheets.
Any suggestions about how to speed up COUNTIF and SUMIF in Excel 2003?