Posted 16 November 2022, 4:11 am EST
My team tried to develop feature to manually execute formula calculation as a way to improve large sheet performance.
I noticed spread object contains an option called calcOnDemand, I have tried to turn it on but nothing happened.
Can you show me an example on how to turn off automatic formula calculation on sheet if that is possible? Much appreicated.