Forum Discussion
Excel... stopped calculating automatically
Hi! What could possibly be the problem? I made my own budget file with charts and itworked well for months. Now, all of a sudden... I have to reselect somme all the time to see the result of my colum...
Hi Hans.
I have recently found that my Excel version has started to default to Calculation Manual, which is a pain given that is a setting I have never used. I would rather switch to compiled code than use the Manual setting. Do you know how to reset the default? Is the setting picked up from a template file? Changing the setting in Options is good for the rest of the session but not beyond.
Unless its a bug introduced in the latest version of Microsoft 365, I would indeed suspect a template or add-in.
How is Calculation Options set if you start Excel in Safe Mode by holding down Ctrl?