VBA Turn off circular reference warning

[jscranton]

I have a "master" excel that loops through a folder of excels, opens them, runs a variety of macros and then saves and closes them. I have always had some excels that crash the application and I finally narrowed it down to excels that have a circular reference in them. I have disabled alerts and so Excel just crashes completely. I have tried several ways to turn off this warning including:

  Private Sub Workbook_Open()
       Application.calculation = xlCalculationManual
       
      If errormsg Then
          SendKeys "{esc}", True
      End If


   End Sub

Neither of those seem to work. Any other ideas?

 

[AlphaFrog]

Try this...

Application.Iteration = True

From the VBA help (F1)

Iteration Property
Microsoft Excel will use iteration to resolve circular references.

Note: this is an application level setting. Set it for an instance of Excel and it applies to all workbooks.

 

[mole999]

change the number of iterations > excel options > formulas > maximum iterations

though the potential is there are errors in the values and that might effect the results you are pulling

Application.MaxIterations = 1