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 it copies the Subtotal formula into each cell of the insert row. The Clipboard is empty.
Many thanks
1 Reply
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.
