I'm trying to Importrange() from a range containing 240,000 cells (40 columns, 6000 rows). The Importrange() function is erroring out with results too large.What are the limitations of Importrange()? I can't seem to find this documented anywhere. How can I get around this so I can import that data into my sheet?
Importrange() Error: Results Too Large, how to work around?
google spreadsheets
My experiments on this would suggest that there is a max limit on the number of items that you can import using importrange() which id not linked to the total number of cells in your Google Sheet. This figure seems to be around 175,000 cells. I'm not sure if this is the offical max, but that's the most I have been able to import without getting a 'too large' error. 