1

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 sort of cell dependencies so to do the minimum recalculation?

Example:

enter image description here

Will sheets spend time doing the lower part of the orange box?

If the data in the yellow box changes, will ONLY those cells dependent on the yellow box be recalculated?

4
3

Google Sheets only calculates a formula when the data it refers to changes. In other words, if the data in the yellow box changes, only the cells dependent on the yellow box will be recalculated.

The exception is with volatile functions like indirect(), rand() and now() that are recalculated every time any value in the spreadsheet changes.

To improve spreadsheet performance, see these optimization tips.

1
  • This is what I expected. I had someone who was critical of a sheet because it had 27,000 unused formulas. Thank you. Apr 25 at 15:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.