Excel takes this setting from the first workbook opened in a session. This setting applies to all open workbooks in a session, no
matter what their original setting was.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"TeresaD" wrote in message ...
|I am experiencing a problem with my Excel formula options. I opened a
| workbook that was set to manual calculation. I went into formula's , changed
| it to Automatic, went into Excel options and made sure it was set to
| automatic. Then saved the file, and exited Excel. I then opened the same
| workbook back up and it was back to manual calculation. Why won't Excel
| retain my calculation settings?