If Excel works Slow

If excel in your system work slow kindly follow below steps.

1. Reduce as many array formulas as possible

2. Use Conditional Formatting as minimal as possible - use it only for exceptional reporting

3. Clean (clearcontents and delete) excess rows and excel columns in your data sheets

4. If you have multiple pivot tables coming out of same data area, then try to ensure that they all use the same Pivot Cache

5. Avoid using Volatile Functions like VLOOKUP, TODAY(), etc. in your file

6. Unless absolutely necessary, try to keep other workbooks closed while working with this large file