A simplified spreadsheet showing the issue is available here

As you can see on the sheet, columns I through M all have sporadic failures in them. I'm unable to figure out why these fail. The use of QUERY() was suggested in this question and at first I thought it was the answer, but then I started seeing failures as I filled it down my sheet.

I appreciate any insight as to why these failures occur.

OK WTF - literally as I was about to press the POST button, I checked the sheet one last time and all but ONE error are now gone. The only remaining error at this moment for me is in cell I4. However in my original larger sheet, the errors persist as they did before I made this cut-down version.

And now about a minute later, even that one error is gone. But then I reloaded the page and the errors are back, identical to when I started this question. Same is true on my real sheet. I don't know what to make of this... I truly don't.

  • And as of this moment the errors are all gone again. Color me confused.
    – JVC
    Aug 11 '16 at 4:50
  • You should mention the use of IMPORTHTML on several formulas as this is what is causing the problem, actually the same happens with IMPORTDATA, IMPORTRANGE and custom functions. I think that the root cause is related to the network latency, the source data automated queries limits and Google Sheets recalculation execution time limits.
    – Rubén
    Aug 11 '16 at 11:31
  • Related: webapps.stackexchange.com/questions/97403/…
    – Rubén
    Aug 11 '16 at 11:42

The only sure-fire solution I've found, after days of scouring the web and trying everything I could find, is to use ImportXML. It appears to work consistently every time, while importhtml() fails quite frequently. Here is the tutorial I followed, it's actually incredibly easy to use and works far better!

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.