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

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?

CodePudding user response：

These errors are usually temporary and go away in a few hours. To expedite that, modify your import formula slightly by replacing "sheet1!B:B" with "sheet1!B:b" — the small letter case change is enough to let the call duck Google's cache and get fresh results, which should let you work around the issue.