colinlegg.wordpress.com
#REF! Means Your INDIRECT() Formula May Be Slow As A Dog
A user recently handed me a spreadsheet and asked me to investigate some bizarre behaviour. For some people the spreadsheet’s calculation was fast, for others quite slow and, for a few, extre…