May 21 2020 05:22 PM
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 and I are simple numeric fields, be it Dollars or Unit.
However, lately it always return with errof #SPILL and wont do anything.
Checked the Online Help and it says "The spilled array formula you're attempting to enter will extend beyond the worksheet's range. Try again with a smaller range or array." which is not the case.
Appreciate any input from the Experts here. Thank you!
May 21 2020 07:54 PM
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.
May 21 2020 08:53 PM
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 ...
May 21 2020 10:11 PM
Solution
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.
May 24 2020 03:48 PM
May 21 2020 10:11 PM
Solution
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.