I have a lot of independent functions and information in my sheet, and every time I make a slight change somewhere in the sheet, it seems like the entire sheet is being saved and re-updated. So every (automatic) save slows down my spreadsheets tremendously. It is hard to tell, because sometimes the re-updating occurs immediately, sometimes after a while, and sometimes it doesn't happen at all.
If I am correct about this, how can I change it so my spreadsheet updates only when I prompt it to?
In File->Spreadsheet Settings there are three recalculation options. I'm not sure if they are specific to:
how often NOW, TODAY, RAND, and RANDBETWEEN are updated.
or what that actually means is how often any input is updated, but in any case, all three options include a recalculation after
On change, which, if applicable to my case, is too much.
How do I make it that updating of inputs is only when I decide it?
Otherwise, every time I make the slightest change, the entire large document takes its time saving and recalculating the inputs, and I can't get anything done.