google-sheetsgoogle-sheets-formula

Google Sheet IMPORTRANGE Error "Import Range internal error" When Range is just a column

In Google Sheet IMPORTRANGE function for single column in rage

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1-bCoiKLjBlM5IGRo9wrdm", "sheet1!B:B") I get

"Import Range internal error."

But for

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1-bCoiKLjBlM5IGRo9wrdm", "sheet1!B:C"), it works.

Is it a bug? up to now, it was the third time that I had to change them many times? Is there any consistent solution for it? I use this solution as temporary

=Query(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1-bCoiKLjBlM5IGRo9wrdm", "sheet1!B:C") , "Select Col1")

Finally:

I didn't get error for 5 day right now And in this link https://issuetracker.google.com/issues/204097721 has now been marked as fixed in the issue tracker.

Solution

  • This could not be the solution to the problem. I have built a whole data integration platform up on sheets and rely heavily on importrange functionality to shield off access to datasources from users. Now lately the #REF started to haunt my tables all over the place and it renders everything more or less unusable.

    Definately this is a bug or lack of resources.