Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [google-sheets-performance]

For questions about the performance of Google Sheets.

0
votes
1answer
17 views

How can I track down the bottlenecks in Google Sheets? [closed]

Given a complex multitab Google spreadsheet, what tools and methodologies are there to find what is slowing down my sheet execution? I'm seeing behaviour where the ribbon that shows recalc progress ...
-1
votes
1answer
46 views

How to test performance of a Google sheet formula?

I was wondering, whether ARRAY_FORMULA() enclosed by COUNT() work much slower than COUNTIF() without ARRAY_FORMULA(). How to test/compare performance of formula that uses a range as parameter?
-1
votes
1answer
20 views

Are Boolean expressions short-circuit evaluated in Google sheet formulas?

Suppose I have the following expression repeated in a long column: =IF(OR($U2=""; COUNT(aHugeRange)=0); ""; SUM(aHugeRange)) I would like to avoid performing COUNT() and SUM() as much as possible to ...
4
votes
1answer
7k 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 ...
1
vote
1answer
1k 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
0answers
866 views

Which of the functions INDIRECT or IMPORTRANGE slows down my Google sheet the most?

I have a master Google sheet that: Uses the importrange function to fetch data from eight different columns in 8,191 separate Google Sheets (files, not only sheets/tabs). To be extra clear: in this ...
0
votes
2answers
3k 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 ...
5
votes
1answer
5k 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 (...
2
votes
1answer
76 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 ...
8
votes
2answers
4k 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 ...
3
votes
1answer
5k views

How can I speed up my Google Spreadsheet Script?

I am somewhat new to JavaScript and very new to using it in Google Spreadsheets. I have read that fewer calls to Google Spreadsheet API speeds things up, but I feel like I have as few as possible at ...
1
vote
2answers
537 views

Is there a way to speed up the auto-increment routine in Google Spreadsheets?

The solutions that have been provided for this question does the job, but when more people submit data at the same time, things go wrong. The same number is used in multiple rows. Is there a way to ...
3
votes
1answer
1k views

Google Docs brings Firefox to a grinding halt

I've found recently that when I open a not-too-large* spreadsheet in Google Docs, within about 5 minutes of leaving it in a background tab, Firefox starts hogging 100% processor time. Closing the main ...