I have a spreadsheet containing 32,000 rows and 45 columns. There are Excel formulae in some cells. When I apply a criterion in the filter (such as choosing the rows of price above $2,000) or clear the filter, it usually takes more than 10 minutes even 30 minutes to finish it as the calculating (8 processor(s)): xx% is shown in the status bar.

Is it normal for Excel to take so long time to finish filtering?

Also, I found that the filter can be done very quickly if I use this setting: Formulas->Calculation->Calculation Options->Manual. However, no formula in the cells will be recalculated automatically, as the setting implies.

It seems that the formulae are recalculated during applying the filter and that causes filtering to take a very long time. I think it does not need to recalculate the formula during filtering because it just needs to search the rows satisfying the filter criteria.

Is there any way to make the filtering faster in Excel?