How to Recalculate a Spreadsheet
The dependency graph is why you should always prefer INDEX over OFFSET, unless you really can't avoid it:https://docs.microsoft.com/en-us/office/client-developer/exc...Every instance of OFFSET in your sheet is recalculated after each cell change. I learnt that the hard way.