Formulas stop calculating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Formulas in my workbook are no longer calculating automatically. My settings
in Tools are correctly set to calculate automatically - AND - using F9 is
also not working. Any ideas why the calculations will no longer work?
 
Is your sheet displaying the results or displaying the formulas. If
formulas, try doing ctrl+~ to toggle between formula view and regular view.

try

Ctrl+Alt+Shift+F9

Make sure you still have formulas - you didn't inadvertently do copy, then
paste special values.

Obviously recheck Tools=>Option even if you think it is correct.
 
Back
Top