Forum Discussion
Rodney27
Sep 04, 2023Copper Contributor
Manual calcuation
I have recently (Maybe last 2-3 weeks?) that might existing workbooks are opening up with the calculation option on manual. These were all previously on auto. Is this an Office update issue? than...
Rodney27
Sep 04, 2023Copper Contributor
Thanks Detlef.
I never use any workbooks in manual mode, so I don't know how this happened in the first place. Every workbook I find in manual mode, I change to Auto and save. Shouldnt this reset it to saving everything in auto now?
I never use any workbooks in manual mode, so I don't know how this happened in the first place. Every workbook I find in manual mode, I change to Auto and save. Shouldnt this reset it to saving everything in auto now?
Detlef_Lewin
Sep 05, 2023Silver Contributor
Well, at least you have to change the calculation mode to "automatic" in every workbook.
- Rodney27Sep 05, 2023Copper ContributorI think it may have related to a personal.xls file which loads in xlstart. There was a "recovered" version too, so maybe something had gone wrong & reverted to manual. Thanks for your help 🙂