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...
Detlef_Lewin
Sep 04, 2023Silver Contributor
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_LewinSep 05, 2023Silver ContributorWell, 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 🙂