I believe there is a setting in the options to allow for iterative calculations:
In Excel (windows), go to File/Options/Formulas and enable Iterative Calculation. In Excel (mac), go to Preferences and then look under heading “Formulas and Calculation” and open “Calculation”, then click box...