Questions tagged [google-sheets-performance]
For questions about the performance of Google Sheets.
17
questions
1
vote
1
answer
131
views
Multiple large GOOGLEFINANCE formulas make spreadsheet unresponsive
Problem
In Google Sheets I have huge GOOGLEFINANCE formulas that return accurate results however the sheet is often unresponsive, and can take a few hours to recalculate when reloaded.
Is there a way ...
1
vote
2
answers
45
views
Is it possible to do a more concise IF x = 1 OR x = 2 OR x = 3 in Google Sheets?
The following is a part of a formula I'm using to filter for week day rows (for conditional formatting):
OR(
MOD(ROW(),7)=2,
MOD(ROW(),7)=3,
MOD(ROW(),7)=4,
MOD(ROW(...
1
vote
1
answer
2k
views
service spreadsheets timed out while accessing document with id, after copy some data between spreadsheets
I need to copy data from one spreadsheet to another every day.
There is 13 columns and about 50k rows (counts of rows is growing with time).
But from time to time, after copy some data, function is ...
0
votes
1
answer
38
views
Spreadsheet Speed In Terms of WorkBook vs WorkSheets
This is a very simple question. Excel calls their individual documents Workbooks, and their "tabs" sheets. Google has a naming problem with their products, and makes this confusing.
I have a slow ...
1
vote
2
answers
2k
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 ...
0
votes
1
answer
185
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 ...
0
votes
1
answer
1k
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?
3
votes
1
answer
521
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 ...
5
votes
1
answer
17k
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 ...
2
votes
3
answers
10k
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
2
answers
4k
views
Which changes will have the most impact on recalculation times for a very large and slow spreadsheet?
I have a huge spreadsheet in Google Sheets and it takes about a half-minute to recalculate after every change. During this delay, the user interface is responsive, but there's a slow progress bar ...
8
votes
2
answers
15k
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 (...
3
votes
1
answer
365
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 ...
14
votes
2
answers
11k
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 ...
4
votes
1
answer
8k
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
2
answers
613
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 ...
4
votes
1
answer
2k
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 ...