Forum Discussion
Inconsistent Formula
Hi Why do certain data cells show as Inconsistent formula alert when the contents are simply numerical data e.g. R3 and others don't? Secondly, if I attempt to insert a blank row into the table ...
That's since there were formulas like =+SUMPRODUCT($F$139:$F$142,#REF!) in these cells, Excel remembers initial formula. To avoid, select entire column, delete everything and start typing numbers.