Forum Discussion
Andrewtickner
Sep 22, 2020Copper Contributor
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 ...
SergeiBaklan
Sep 22, 2020MVP
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.