Avoid OFFSET and other volatile[0] functions in Excel. Use things like INDEX instead.
[0] Volatile functions are those whose value can be affected by a large number of other cells, and Excel doesn't know which cells until it evaluates the function. So whenever any cell's value changes, all volatile functions must be recomputed. This can cause a ripple effect, too, making your spreadsheet grind to a halt or take hours to become responsive.
2 comments
[ 3.9 ms ] story [ 22.4 ms ] thread[0] Volatile functions are those whose value can be affected by a large number of other cells, and Excel doesn't know which cells until it evaluates the function. So whenever any cell's value changes, all volatile functions must be recomputed. This can cause a ripple effect, too, making your spreadsheet grind to a halt or take hours to become responsive.