HOW TO FIX CIRCULAR REFERENCES IN EXCEL


PC: In Excel, to to File -> Options -> Formulas

MAC: In Excel, go to Excel -> Preferences -> Calculation

Tick 'Use iterative calculation', set Maximum iterations to 50 and Maximum change to 1.


Home Features Downloads Contact Us F.A.Q.s