Table formula recalculating on new table row when recalculation is set to Manual.

[HighAndWilder]

I have a table with various formula that use XLOOKUP.

When a new table row is created and a value is entered into column two, these formula recalculate using the value entered as the lookup value.

I have recalculation set to Manual so why is this happening and is there a way to stop it happening?

Thanks

 

[shift-del]

It doesn't happen in my workbook.
I suggest creating a new table or a new workbook.