Feb 05 2023 11:16 AM
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 column... same happens when I use a formula without chart. Any clue guys?
Feb 05 2023 11:23 AM
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.
Feb 05 2023 11:36 AM
Feb 05 2023 11:52 AM
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.
Feb 05 2023 12:17 PM
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?