You don't have to check every calculation and formula you've applied in the file, but those primary ones tend to eat a lot of your computer's resources. Formulas that reference entire rows or columns SUMIF, COUNTIF, and SUMPRODUCT A large number of formulas Volatile functions Array ...
3. Next, it’s time to use an Excel formula to link your data to your MIS template. You can use Vlookup, Hlookup, Sumifs, Sumif, etc. formula depending on your need. 4. Finally, don’t forget to check your report on whether numbers are following the trend or not, any #N/A, ...