Hello,
Every time I open Excel, the Automatic Calculation is set to manual. I go
into Tools -> Options, click the Calculation tab and set it to Automatic.
However, each time I reopen Excel it gets reset back to manual.
It was working fine and then one I day Excel crashed and it hasn't been the
same since.
If it makes a difference, when I open Excel, it is opening a Personal.xls
file, there are also some add-ins that I have. However, I never put any code
to make it shut the Automatic Calculation off.
Thank you for the help.
-Gumbatman
Jim Rech - 15 Aug 2007 16:45 GMT
Calc mode is set by the first workbook opened, probably Personal.xls in this
case. I'd guess you last saved it with calc manual. So try resaving
Personal after setting calc to automatic.

Signature
Jim
| Hello,
|
[quoted text clipped - 12 lines]
|
| -Gumbatman
Gumbatman - 17 Aug 2007 15:07 GMT
Jim,
You were right. It now works correctly!
Thank you for the answer.
-Gumbatman
> Calc mode is set by the first workbook opened, probably Personal.xls in this
> case. I'd guess you last saved it with calc manual. So try resaving
[quoted text clipped - 18 lines]
> |
> | -Gumbatman