3

Working with a Google Sheet that has grown in complexity and size over time and is now calculating endlessly and really slow to open. The sheet has a large amount of data, formulas and import ranges.

I have read best practices on how to speed up sheets link. Does anyone know how to do advanced trouble shooting in Chrome Dev tools to see what formulas are running when and help narrow down what could be causing the problem?

I have used Chrome Dev Tools and the Performance Monitor, but can't see how to locate actual formula [Ex: Sum() or VLOOKUP()] names/location from within the sheet since they are nested under so many layers of functions. (Ex: Function Call > b > P.I2b > p.$Ma > etc)

Chrome Dev Tool Performance Screen Shot

Rubén
  • 34,714
  • 9
  • 70
  • 166
Cory
  • 45
  • 5
  • 2
    @Calculuswhiz While there are some functions that depends on the server (i.e. GOOGLEFINANCE) most of the spreadsheet calculation is done on the client side. – Rubén Oct 14 '20 at 01:34
  • How much data is in the spreadsheet? – Oleg Valter is with Ukraine Oct 16 '20 at 02:40
  • Current data size is about 500 rows and 30 columns. I'm trying to find a more general solution to pinpoint the issues there the calculations are getting hung up. – Cory Oct 16 '20 at 18:48
  • 500 rows and 30 columns isn't that big, I typically don't get slowed down until I am around 4000 rows. Try to avoid using the same importrange() in multiple formulas, import it once into another sheet, then reference that cell. Then it only has to call importrange once. – Kris Mar 26 '21 at 19:48

0 Answers0