There are some proven techniques to optimize your formulas and dramatically speed ... your sheet, Excel will recalculate the formula. For example, instead of using =A5-NOW() formula to calculate ...

Use the formula triangle to establish the correct calculation by covering up what needs to be worked out. To work out speed, cover the S. To work out distance, cover the D. To work out time ...