Questions tagged [google-sheets-performance]

For questions about the performance of Google Sheets.

Filter by
Sorted by
Tagged with
5
votes
1answer
16k views

How can I speed up Google Sheets?

I'm looking for insights on how to make Google Sheets update more quickly. At present my spreadsheet has 22 sheets with 15 to 100,000 cells each. Mind you many cells are blank. Cust_Orders has a ...
11
votes
2answers
9k views

Where does the calculation take place?

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 ...
7
votes
2answers
12k views

Google Sheets updating after every change, which is too often, slowing everything down

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 (...
0
votes
2answers
4k views

Which factor will give most speed up to every update to a large Google Sheets?

I have a huge spreadsheet in Google Sheets and it takes about half a minute to complete every change I make to its contents: user interface stays responsive, but there's a slow progress bar showing ...
3
votes
1answer
244 views

What's causing / how to get rid of long web calls in Google Sheets?

I have a Google Sheets that's running into performance problems. It will make really long calls and occasionally freezes up the user interface. Here's an example of the type of call that's being made ...
2
votes
3answers
7k views

CPU vs. RAM for Google Sheets

I use Chrome and Google Sheets with large spreadsheets which have IMPORTRANGEs, VLOOKUPs and pivot tables. I am looking to improve speed. For this use which has the bigger impact CPU or RAM? Perhaps ...
0
votes
2answers
921 views

How do I find out what is slowing down google sheets?

I have a multitab google sheet that now and then slows to a crawl. The progress ribbon takes several passes to before it quits. At times the progress ribbon stops entirely for minutes at a time. This ...