
 There is a setting under Data:Calculate: (choose) AutoCalculate. I have used F9 to recalc. Sometimes this doesn't seem to work, usually when a formula references another spreadsheet. Example: ('file:///C:/Users/Balance.ods'#$CheckingSt.J12). I have exited and reloaded one or both spreadsheets involved and had the formula work again. If I just try to edit the formula, it sometimes works but often the whole formula must be reentered. I prefer to try unloading and reloading the spreadsheet rather than rethink the logic of a long formula. Looking for this setting just now I see there is Hard Recalc (Sht+Ctl+F9) that I will have to try.
 
