title: Excel - Iterative calculations convergence issue / infinite loop
body: <p>I am developing a vehicle lap time simulation using Microsoft Excel 2016.
  The spreadsheet I have built so far is fairly complex and involves few thousands of rows and many circular references between the columns, which are around 50.</p>
  
  <p>The problem I am experiencing is that of calculations not converging: iterations (making use of the built-in algorithm) never stop and values continue to change; in particular, cells containing formulae like "equal to another cell" return values which do not comply with such formulae, being slightly different from those in referenced cells. This happens regardless of the "maximum change" value in the settings.</p>
  
  <p>Results are overall in line with expectations, but these small deviations make the spreadsheet difficult to use because of the never-ending calculations.</p>
  
  <p>One thing I realised is that all columns reference at least another: could this originate the problem, given the lack of an "initial guess"?</p>
  
  <p>Anyway, could this issue be related to any known limitation of the algorithm or is it something that can be solved by adjusting settings or the workbook itself?</p>
  
  <p>Thank you for any help you can provide.</p>