Question: how to get excel to calculate quicker?
Answer: Try using “faster formulas” ...  Avoid volatile formulas. ...  Avoid large ranges. ...  Replace formulas with values. ...  Avoid conditional formatting. ...  Decrease the number of worksheets. ...  Use multi-threaded calculation. ...  Use 64bit version of Excel.