Sorry, I should have clarified.
Default behaviour with Excel is to recalculate each formula etc when a spreadsheet ios opened, and when a change is made to a formula. Which mostly is sensible.
But if you are managing large data you don't want ti rippling through thousands of formulae each time you change something so you can change it to manual. In my version it's under Formulas, Calculation Options.
maybe Open Office defaults to that, or recognises the size of the spreadsheet and sets itself accordingly - or maybe it's simply quicker.
Either way, beware if using manual calc as it is all too easy to fail to update it once you've made your changes!!
EDIT: Crossed posts with Manatee!
Last edited by: smokie on Thu 30 Jul 20 at 12:58
|