Aug 14 2020 02:24 AM
Aug 14 2020 03:38 AM
Activate the Formulas tab of the ribbon.
Make sure that Automatic has been selected in the Calculation Options dropdown.
Aug 14 2020 09:01 AM
IMHO, F9 shall work independently of this setting. Ctrl+Alt+Shift+F9 gives bit more, but it depends.
Aug 14 2020 12:20 PM
Hi Sergei, I am aware of that, but the OP stated "we have to keep pressing f9 function to populate changes". I took this to mean that automatic recalculation has been turned off.