Forum Discussion
Solved
#SPILL! Error when doing simple calculation
Greetings! I have had this problem in the past few months I think, after having used it for 20 years. Often I add or subtract columns, such as =+X:X+I:I, and never had any issue. Both Columns X ...
but suffice to say I much prefer just to use a column, instead of a fixed field.I used to be able to do this in the past 10 years ...
The keyword is "new calculation engine". Either you adapt to this or you have to revert from Excel 365 to Excel 2019.
There is a third option for the formula which enforces implicit intersection: =@X:X+@I:I. And copy down.
but suffice to say I much prefer just to use a column, instead of a fixed field.I used to be able to do this in the past 10 years ...
The keyword is "new calculation engine". Either you adapt to this or you have to revert from Excel 365 to Excel 2019.
There is a third option for the formula which enforces implicit intersection: =@X:X+@I:I. And copy down.
