Forum Discussion
EddieChan
Feb 04, 2021Copper Contributor
update the calculation in array formula
I read the tutorial of array formula and have tried some example, I would like to know how why the array formula do not update the calculation automatically after I change parameter input ??
I need to click the cell that contain array formula and press F2 to enter edit mode and press "enter" for updating the calculation.
please advise if any setting I have missed ??