enable iterative calculation excel 2016 untick itself

[handri]

How do i rid this setting in Excel options (formula). Seemed sometimes this box was untick by itself.
And cause error of "these are one or more circular references.." appeared when opening my workbook. Is this anyway to fix this by VBA or any method. I don't need to adjust the tick box every times a when message box appeared.

In the meantime, thank you so much for your attention and participation.

 

[handri]

Fixed. by adding this VBA code in workbook.

[COLOR=#2A2A2A][FONT=&quot]Private Sub Workbook_Open()[/FONT][/COLOR][COLOR=#2A2A2A][FONT=&quot]    Application.Iteration = True   [/FONT][/COLOR]
[COLOR=#2A2A2A][FONT=&quot]End Sub[/FONT][/COLOR]