there are times when i've inserted a column in middle of worksheet and
formulas magically appeared in that column (duplicated formulas which existed
on either side of inserted column). did i imagine this, and is this a
workbook option i can control?