Manual Calculation
I know, I completely exited Excel and I made sure that the file I saved as
Automatic Calculation was the first file I opened when I got back into Excel,
and it still opened in Manual Calculation.
"Niek Otten" wrote:
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?
|