Solved

# Manipulating an Excel Spreadsheet With Iterative Formulas

Posted on 2010-08-27

We're writing a .NET 2.0 app which accesses and manipulates an Excel spreadsheet using TMS Flexcel Studio (the target computers might not have Excel installed). The spreadsheet makes use of iterative formulas which have circular references. This is fine if you're using Excel itself as it has an option to turn on iterative caculations. However changing values via a .NET component causes the formulas to stop updating after the first change presumably because of a circular reference error. Is there a solution out there which would allow iterative calculation to work?