Well, there are various ways to handle slow Excel workbooks. But, here are a few ways in which you can handle workbooks.
- Try using manual calculation mode.
- Maintain all the referenced data in a single sheet.
- Often use excel tables and named ranges.
- Use Helper columns instead of array formulas.
- Try to avoid using entire rows or columns in references.
- Convert all the unused formulas to values.