How to speed up performance of Excel

Reduce Operations

The number of cell references and operations has the biggest impact on workbook performance, not the number of formulas. A few smaller helper formulas are usually more efficient than one enormous formula.

If possible, avoid the use of the same formula repeatedly in multiple cells by taking it out and using in a separate cell. You can then link all those cells that need to use the formula, to that single cell.

Read more.