Maybe you have a workbook already open that has calculation set to Manual.
Calculation is an Excel-wide setting, set by the first opened workbook until manually changed.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Ruth" wrote in message ...
|I have not changed any settings on my computer and for some reason excel
| keeps changing my options in excel to manual calculation instead of
| automatic. Why is this?