Camille Rethoret
Reputation: 75
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.
Upvotes: 4
Views: 16834
Answers (1)
nbayly
Reputation: 2167
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,
Upvotes: 10
Related Questions
- How can I disable automatic recalculation on google sheets?
- turn on/off automatic calculation in only a few columns in Excel
- Disable Google Sheets formula
- How to stop automatic recalculation in excel
- Can you permanently disable auto-calculate on specific sheets in a excel workbook
- Stop a custom function from recalculating every time the spreadsheet is open?
- Turn On Automatic Calculations
- Google Spreadsheet - disable editing
- How can I enable and disable expensive calculations in an Excel spreadsheet?
- How to disable the Calculate Cells option before opening the workbook?