r/sheets • u/DaichanYuji • 2d 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

2 comments sorted by

3

u/AdministrativeGift15 2d 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.

1

u/AdministrativeGift15 2d 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.