Dynamic Array Not Updating Until I Press Enter

Question

I have an array formula which use to update automatically when I change the values. Now when I try to use array formula it would not update until I press enter in the formula bar each time when I enter new values. That defeats the whole purpose of dynamic arrays.

Dynamic Array Formula:

FILTER(Table3,ISNUMBER(XMATCH(Table3[DBK],I2:I10)))

I update I2:I10 with new values. Then array used to change automatically.

Answer 1

Check that Calculation Options on the Formulas tab of the ribbon is set to Automatic.

Also check that you don't see Circular References in the status bar at the bottom, to the right of Ready;

Answer 2

Thank you!

Calculation options was changed to automatic.