If you were lucky they’d be finished when you returned. I remember the old days when you would set hundreds of thousands of VLOOKUP formulas loose on your dataset and then go out for lunch.
Use Filter, Unique and Array_Constrain functions to create smaller helper tables.Manage expensive formulas with a control switch.Use IF statements to manage formula calls.Remove volatile functions or use with caution.Convert formulas to static values wherever possible.Measure a Google Sheet’s calculation speed.What follows in this article is some suggested optimization strategies and some research into what causes slow Google Sheets. How can you speed up a slow Google Sheet?įirst off, this is a difficult question to answer because there are so many factors that may or may not be causing you to have a slow Google Sheet.
We’ve all been there, stuck watching the little loading bar creep slowly, frustratingly to its conclusion: (Updated Jan 2022 to reflect the increase in the cell limit of Google Sheets to 10 million.)
