is it possible to specify to Google spreadsheet not to recalculate a specific sheet or number of cell everytime a modification is done ? I have a very heavy sheet and it's very slow everytime i made a tiny modification, even if it's in an another sheet.
Seems that this feature is not supported by Google Spreadsheets. From a cursory search online the easiest way to work around this limitation is to make your formulas all conditional on a trigger. ie =IF(Boolean_Trigger,Your_formula,"")
. Trigger could be a cell, Named range, etc. Regards,
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With