Module VI· Sensitivity & Scenario AnalysisIntermediate
Question
How do you update data tables when iteration is ON?
Answer
Data tables can calculate slowly or inconsistently with iteration. Set calculation to automatic except data tables if needed, force recalculation with F9, and check center cases manually. For circular models, use a circularity switch or paste values for final sensitivities if data tables are unstable. Always sanity-check outputs.