Excel formula is not being applied to some entries

Question

I have a workbook that gets its data from a SharePoint library. The idea is to automatically generate reports from the excel workbook and send automatic emails with the report attached. Problem is: recently, after the workbook refreases, formulas are missing in some cells making the reports incorrect. What is causing the formulas not to be applied in some cells?

Answer 1

Make sure filters are cleared before inserting the formula. Filters make some rows hidden and the formula is not applied to them.