IOS Numbers not updating Formulas Until file Closed then Reopened.
I have a Numbers file which I normally use on iPhone or iPad. It contains about 10 small sheets and a couple which are about 100 rows by about 10 columns.
I’ve just started a new sheet with date in first column then about another 5 columns some have basic formulas, others don’t. I notice when I try to add another formula to a new column and hit Return, it shows completely empty as though I just did nothing . I can even Fill Cells downwards and the same empty cells show. As soon as I close the file and reopen it , the cells now show the new formula and I can quickly see them update before they settle.
This doesn’t always happen and as I don’t really use other files so I can’t really say if it happens elsewhere. Have I unticked some kind of AutoUpdate box somewhere or similar?
Thanks for any help in advance,
iPad, 17