It's known that "Calculating formulas" in Google Sheet disaster is a problem in general, but I have a specific question - does it help at all if I or other concurrent users exit the sheet or does it not matter at all? I mean, will the formulas calculate faster or slower if anyone exists?
TL;DR: It depends.
To put it simplistically, while the users who have opened the spreadsheet simultaneously do not cause any change, they will not affect significant other users. Your mileage might vary.
Sometimes, the browser has problems handling the resources. The performance of coordinating the back-and-forth communication between the multiple browser tabs and Google servers might be affected by many things, which might cause problems with the recalculation.
Asking all users to close the spreadsheet will be helpful. It will work as taking time off of sending changes to the server and requesting the browsers to execute the recalculation.
Sometimes, the problem might occur to a single user. I.E. due to having low resources in their computer. Before asking others to close the spreadsheet, you might try first to do it yourself; if that doesn't work, close and restart the browser.
- The presence, active cell, and active selection real-time indicators consumed bandwidth is relatively minimal.
- I have not run formal tests. Still, by experience, I know that independent volatile functions, i.e.,
=NOW()not having any dependent formula, will not cause a recalculation of the spreadsheet of the other users due to events like spreadsheet opening or the spreadsheet frequency recalculation.
- Be careful when designing Google Apps Script functions to be called by triggers (open, edit, change, form submit).
- Be careful when integrating apps like Zapier, IFTTT, etc.
- Filters change the spreadsheet.
- Ensure that the spreadsheet users understand this.
- Ensure spreadsheet users know how to use filter views and convince them to use them instead of filters.
- Data validations drop downs change the spreadsheet.
- Avoid using a single spreadsheet to simultaneously hold form-like sheets with complex dependent drop downs.