title: Filtering in large spreadsheet takes long time
body: <p>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 <code>calculating (8 processor(s)): xx%</code> is shown in the status bar.</p>
  
  <p>Is it normal for Excel to take so long time to finish filtering? </p>
  
  <p>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.</p>
  
  <p>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 <em>need</em> to recalculate the formula during filtering because it just needs to search the rows satisfying the filter criteria.</p>
  
  <p>Is there any way to make the filtering faster in Excel?</p>