Formulas stop calculating

[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?

 

[Tom Ogilvy]

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.

 

[Arvi Laanemets]

Hi

Aren't cells with formulas formatted as text?