Contents
How do I fix an Importrange error?
But for now, let’s troubleshoot your IMPORTRANGE formula and fix the current error….How to fix
- Hard refresh of the sheet and/or browser.
- Re-adding the IMPORTRANGE formula to the same cell (use the Google Sheets shortcuts Ctrl+X and then Ctrl+V or clear the cell and use Ctrl+Z to restore it)
- Nest IMPORTRANGE with IFERROR.
How to work around the importrange error?
My results could be 600 rows or 6000 rows as long as I didn’t exceed 36 columns. Ironically you can get around this by combining IMPORTRANGE functions. Using the answer of Sam and reading documentation, I found the way how to get result of BIG DATA without error. For that you need to make an export step by step. In one query.
Why do I get an importrange error in Google Sheets?
This is more of a warning than an error. When you import a range from an unshared Google Sheets document stored on your Google Drive, IMPORTRANGE will require you to connect the source and the target sheets. Click the Allow access button to connect the sheets. IMPORTRANGE #ERROR! – Result too large
How to fix Google spreadsheet import Range ref?
I do a Find-and-Replace (“search within formulas”) for “=” wherever I have the importrange error (=REF!) (or just for the whole sheet) and I replace-all with a “#” in order to make it all be text rather than formula. Then I do another Find-and-Replace over the same area and replace-all the “#” with “=” again. This consistently fixes the issue.
How to reattempt importrange formula in Google Sheets?
Re-adding the IMPORTRANGE formula to the same cell (use the Google Sheets shortcuts Ctrl+X and then Ctrl+V or clear the cell and use Ctrl+Z to restore it) The sheet will reattempt the data import again and again automatically. Insert a NOW formula ( =now ()) in a random cell of the source and target spreadsheets