Forum Discussion
#SPILL! Error when doing simple calculation
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.
Your formula only worked because of implicit intersection.
Now with new calculation engine you have to change it to X2+I2 and copy down.
Or keep it in the first cell and delete the rows below. Now the formula spills.
Many thanks for your response. Sorry I dont quite know what "implicit intersection" is even googled, 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 ...
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.