Excel keeps calculating - no idea why?

Here is the file with VBA code for macro "ApplyFormula()" and Worksheet_Change event for "PRODUCTION" sheet.

Macro is given to refresh all formulas in PRODUCTION sheet if required.
Worksheet event changes the formula in the row in which B column value is changed. Say B25 is changed then 25th row all formulas are changed automatically.

In both the codes last column is taken as AZ. If you want you can change in the code.
Now the delay due to calculation is not there as indirect formulas are removed.

Worksheetevent

To paste the code
Right click on Sheet tab --> view code
Visual Basic (VB) window opens.
Paste the code
Close the VB window.