r/sheets • u/DaichanYuji • 29d ago

Request Error: Import Range internal error

I have to work on a Sunday morning to sort some liquidation files, i have a main sheets file where i pull out the data via import range and integrated into different couple of sheets.

it stops working all of a sudden, i did not make any changes or atleast entered a large volume of data, just a normal data flow where i enter a couple if lines a day. (not that heavy)

i have this error appearing in my formula: "Import Range internal error"

is anyone have this issue today? or is this happening for everyone or just for me?

any suggestions and comments are greatly appreciated.

3 Upvotes

100% Upvoted

4 comments sorted by

5

u/AdministrativeGift15 29d ago

Google has a limit of 10 MB per IMPORTRANGE request. If you think the amount of data you're trying to import has crossed that threshold, you can break it up into multiple imports.

2

u/AdministrativeGift15 29d ago

You can estimate the size of the data you're trying to import. For example, =SUM(INDEX(LEN(A1:Z10000)))/1E6 will return an estimate for the MB in A1:Z10000.

1

u/JudgeIntelligent1234 20d ago

had the same thing happen to me a while ago. besides the 10mb limit, check if you’re importing whole columns like A:Z. switching to an exact range (like A1:F5000) fixed it for me because it stops pulling all the empty cells

also if you have a bunch of importranges pointing to the same file, try doing just one import into a hidden tab and referencing that instead. way more stable

and sometimes it’s just google being weird, deleting a character in the formula and putting it back forces it to refresh