formula optimization

Excel workbooks that pause after ordinary edits are often being slowed by formula design rather than by the amount of visible data on screen. MakeUseOf correctly flags volatile functions, legacy Ctrl+Shift+Enter arrays, and repeated lookups as common suspects, but its advice needs two important...