I have a master Google sheet that:Uses the importrange function to fetch data from 8 different columns in 8191 separate google sheets (files, not only sheets/tabs). To be extra clear: in this sheet I use the importrange function 8 x 8191 = 65 528 times. In the same sheet I use the indirect function 1 x 8191 times.And also, in the same file but in a different sheet, I use the indirect function 8 x 8191 = 65 528 times to display the results from the importrange query mentioned above (1)  Besides that the master sheet also contains other formulas like the ArrrayFormula but thats problably not relevant for this question.As you might have guessed the spreadsheet is almost impossible to work with. Takes forever to load, freezes, crashes etc. I realize I need reduce the use of demanding formulas like indirect and importrange drastically to achieve a decent performance in the master sheet.Question:Which of the functions (Importrange or Indirect) slows down the sheet the most? In other words: which function should I focus on reducing if better performance is the main goal?
Which of the functions INDIRECT or IMPORTRANGE slows down my Google sheet that most?
google spreadsheets