In Google Sheets I have quite a large number of relatively complex array formulae in many cells that takes ages to complete calculating.
Does the speed of calculation depend on my PC resources, or are calculations processed in Google's servers?
Google Sheets – Where Does the Calculation Take Place?
google sheetsgoogle-sheets-performance
Related Topic
- Google-sheets – Which factor will give most speed up to every update to a large Google Sheets
- Google Sheets Performance – How to Speed Up Google Sheets
- Google Sheets – Create a Multi-User Dashboard
- Google-sheets – Google spreadsheet computation load distribution with multiple computers
- Google Sheets – Wait for Calculations to Update Before Retrieving Cell Data in Apps Script
- Google Sheets Performance – Identify Slowdowns
Best Answer
Short answer
The recalculation speed depends mostly on the local resources.
Explanation
On Google Sheets, most of the built-in functions are run on the client (browser), just some functions like IMPORTHTML, IMPORTXML, IMPORTDATA, IMPORTRANGE, GOOGLEFINANCE require access to the Internet in order to be executed, as well the custom functions because they require Google Apps Script which is run on the Google servers.
You could use something called Google Chrome timeline-tool to check your specific case.
Related questions
Related Google Docs Editors help articles