Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Disable automatic calculation for Google Spreadsheet

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.

like image 361
Camille Rethoret Avatar asked Oct 17 '25 11:10

Camille Rethoret


1 Answers

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,

like image 92
nbayly Avatar answered Oct 21 '25 04:10

nbayly



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!