
Sounds like you have Manual calculation specified...
- Go to Excel> Preferences - Calculation & select Automatic, or
- Use the Calculation Options button on the Formulas tab to select Automatic, or
- Use either the Calculate Now or the Calculate Sheet button on the Formulas tab if you have reason to leave manual calculation selected.