How to Recalculate a Spreadsheet
The dependency graph is why you should always prefer INDEX over OFFSET, unless you really can't avoid it:<p><a href="https://docs.microsoft.com/en-us/office/client-developer/excel/excel-recalculation#dependence-dirty-cells-and-recalculated-cells" rel="nofollow">https://docs.microsoft.com/en-us/office/client-developer/exc...</a><p>Every instance of OFFSET in your sheet is recalculated after each cell change. I learnt that the hard way.