Linked Questions

3 votes
1 answer
25k views

Disable automatically calculation on a single sheet in Google Sheets [duplicate]

I would like to disable automatic calculation on a single Google sheet and then have a trigger, either by button or through some implementation of scripts, inserting a column, etc that will allow me ...
user218351's user avatar
0 votes
1 answer
885 views

Optimize Google Sheets to process/summarize large amounts of data [duplicate]

I have a Google Sheet where data is uploaded from a Google Form in one page and workers input data directly in another page. The data is combined into one table via scripts. I am trying to create a ...
Brian's user avatar
  • 1
0 votes
1 answer
39 views

Point in time data [duplicate]

In google sheets, was wondering if I can do a lookup and capture the data of the return at that point in time instead of continually updating it. For example, if I'm using vlookup to relate item to ...
Felix Pau's user avatar
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 (...
Sirudol's user avatar
  • 105
2 votes
3 answers
8k views

Having Google Sheets not recalculate a formula on page load

I have a Google Sheet with a list of addresses, and a column that geocodes the addresses with mapquest via Google App Script. This works great, except it "recalculates" the addresses on page load. ...
Justin Dearing's user avatar
2 votes
4 answers
2k views

How can I allow results from a Google Sheets 'filter' action to be mutable?

Brief: The results of a filter are not mutable. I cannot directly add/edit rows to the cells in and around a filter result due to a #REF Error: not expanded because it would overwrite data error. ...
Homer's user avatar
  • 81
1 vote
1 answer
393 views

speed up google sheet with large pivot table

I have several pivot tables that present 5-7 columns of data extracted from a sheet that has about 30 column and 5000 rows. That sheet in turn is updated everytime a line is entered in the orders ...
Sherwood Botsford's user avatar
-1 votes
1 answer
748 views

How do I install Spreadsheet Freezer?

I have hear that Spreadsheet Freezer could help me to control when a formula is recalculated. I read on the it's site that I could find the install link here, but I only found questions that point ...
Rubén - Volunteer Moderator -'s user avatar
1 vote
1 answer
324 views

Does Google Sheets do "lazy" calculation?

E.g. - In gnu make, the program keeps a dependency tree for what files depend on what other files. So if one file is changed make doesn't have to 'make world'. In Sheets does it keep a topological ...
Sherwood Botsford's user avatar
0 votes
0 answers
50 views

Sequential update of Google Sheets

On page 1 of my spreadsheet I have a bunch of Google Finance functions to retrieve historical data of various scrips. On page 2 I have some calculations running based on the historical data and on ...
Rajesh's user avatar
  • 1