MicrosoftI'm trying to understand why this is happening. I have created a simple table in Excel, and I want the last column to be a running total, so everything the current row plus the results of the previous row as long as the previous row isn't the title row, which would cause an error. This formula also work 100% of the time when you insert and delete rows in the table.
This formula is in the Balance column of the table.
=SUM(Table1[@[Column1]:[Column5]])+IFERROR(OFFSET([@Balance],-1,0)*1,0)
When I create that formula in the Insider build, it works fine. When I open it on any other build (Monthly Targeted, and the iOS Beta of Excel - 2.19.18110500) it makes it a CSE array formula.
{=SUM(Table1[@[Column1]:[Column5]])+IFERROR(OFFSET([@Balance],-1,0)*1,0)}
But I can edit it on those platforms and make it a normal formula, and it works just fine.
So with Monthly Targeted (1811) I changed it to a normal non-CSE formula. If i change data with Insider, the formulas do not get converted back to CSE formulas, but if I edit the formula, it does.
Seems it is too aggressively converting the formulas when it isn't necessary.