Google sheets recalculate manually

Question

Is there any way to disable automatic refreshing and recalculating a function in Google Sheets?

Working with large sheets that include some functions is super slow, and no need to keep refreshing cells when opening The file. I was wondering if there is any way to disable functions to be refreshed automatically, and enable them again only when needed?

Answer 1

There isn't but you could add this feature by using Google Apps Script.

If your spreadsheet is not "excesively complex" you could save a map of references and the corresponing formulas using the Properties Service, otherwise you might have to save this map somethere else.

Another option is to save this map using the Class Developer Metadata

Related

• Ho do I stop and start autoupdating in Google Sheets?
• Google Apps Script in Google Sheet - Convert formulas to static values - cell function to value
• In google sheets can I wrap a standard function in a custom function to control when it is run?
• How can I disable automatic recalculation on google sheets?
• how to make a custom function NOT recalculate in Google Sheet