Formulas in Cells are evaluated when reading an Excel Workbook. Formula evaluations are not updated when the model is changed in memory or when new elements are added.
All arithmetic formulas can be evaluated. Formulas that contain user defined functions cannot be evaluated.