To update all read functions in a workbook by recalculating all formulas that have changed since the last calculation (including all formulas dependent on them), press F9.