Forum Discussion

Copper Contributor

Feb 05, 2023

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...

Charting

excel

Formulas and Functions

HansVogelaar

MVP

Feb 05, 2023

Martin_B320

On the Formulas tab of the ribbon, make sure that Calculation Options is set to Automatic.

And check whether you see Circular References in the status bar. Circular references prevent Excel from recalculating in many situations.

PeterBartholomew1

Silver Contributor

Feb 05, 2023

HansVogelaar

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.

HansVogelaar
MVP
Feb 05, 2023
PeterBartholomew1

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?