Question: why excel is so slow?
Answer: This is another common reason responsible for Excel running slow, leaving plenty of unused formulas like sumifs, countifs, and vlookups around long can served their purpose. So, try converting them to static values and prevent your Excel file from running slow.