Hello,

I have multiple excel workbooks, where if I insert a row, it stuffs up my formula references (i.e. formulas start referencing the wrong cells) even though I haven’t changed the formula. The rows are not even referenced by the formula indirectly (i.e. it is not part of an array in a SUMPRODUCT).

This never used to happen, and has only started occurring in the past week or so. 

Any help would be much appreciated.

​Hello, I have multiple excel workbooks, where if I insert a row, it stuffs up my formula references (i.e. formulas start referencing the wrong cells) even though I haven’t changed the formula. The rows are not even referenced by the formula indirectly (i.e. it is not part of an array in a SUMPRODUCT). This never used to happen, and has only started occurring in the past week or so.  Any help would be much appreciated.  Read More

​