2

I have a spreadsheet with 62 IMPORTHTML requests. Does it make any difference in speed if I put all of these inside a custom array rather than having them in individual cells?

  • Neither of them ever finish loading because of the large number of requests. – Gnrl Kitty Nov 8 '17 at 20:39
  • Have you tried this? – Rubén Mar 26 '18 at 17:21
1
  • the maximum number of IMPORTHTML() formulas per spreadsheet is 50 and if those 50 are in an array or separately, the difference is none

1

  • Is it possible to circumvent this by placing 30 of the IMPORTHTML calls in one spreadsheet, 30 in another spreadsheet, and then in a final spreadsheet use IMPORTRANGE to merge the resultant tables? – Tyler Gubala Jan 17 at 18:54
  • 1
    @TylerGubala yeah, it should be doable – user0 Jan 17 at 18:57

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.