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.

--
Regards,
Tom Ogilvy




"slc" wrote in message
...
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?

Hi

Aren't cells with formulas formatted as text?


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"slc" wrote in message
...
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?